http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/forums/TechOff/401669-Newbie-question-on-SQL-Server-2005-quotquot-string-concatenation/Newbie question on SQL Server 2005 &quot;+&quot; string concatenationhttp://channel9.msdn.com/forums/TechOff/401669-Newbie-question-on-SQL-Server-2005-quotquot-string-concatenation/en-usTue, 06 May 2008 22:16:50 GMTTue, 06 May 2008 22:16:50 GMTEvNet (EvNet, Version=1.0.3243.35083, Culture=neutral, PublicKeyToken=null)There are a few alternatives to work around the issue. Perhaps the easiest is to translate the null string in the query:<br /><br />SELECT ISNULL(SerialNumber.Number, '') + '-' + SerialNumber.Description AS SerialNumberInfo<br /><br />The other alternative is pull the raw data into the query and perform the contatenation in code:<br /><br />SELECT SerialNumber.Number, SerialNumber.Description<br /><br />string serialNumberInfo = reader["Number"] as string ?? "" + reader["Description] as string;<br /><br />There may be other alternatives, but I think these are the easiest to implement.<br />http://channel9.msdn.com/forums/TechOff/401669-Newbie-question-on-SQL-Server-2005-quotquot-string-concatenation/?CommentID=401809Tue, 06 May 2008 22:16:50 GMThttp://channel9.msdn.com/forums/TechOff/401669-Newbie-question-on-SQL-Server-2005-quotquot-string-concatenation/?CommentID=4018090http://channel9.msdn.com/401809/WebViewBug.aspx?EVT=0There are a few alternatives to work around the issue. Perhaps the easiest is to translate the null string in the query:SELECT ISNULL(SerialNumber.Number, '') + '-' + SerialNumber.Description AS SerialNumberInfoThe other alternative is pull the raw data into the query and perform the contatenation&#8230;lothan0http://channel9.msdn.com/401809/Trackback.aspx<blockquote> <div>Maddus Mattus wrote:</div> <div>Take a look at the ISNULL and the COALSESCE functions, they can help you with your problem.</div> </blockquote> <br /> <br />Thanks a lot. Thats helped me to solve the problem [H]http://channel9.msdn.com/forums/TechOff/401669-Newbie-question-on-SQL-Server-2005-quotquot-string-concatenation/?CommentID=401679Tue, 06 May 2008 08:51:24 GMThttp://channel9.msdn.com/forums/TechOff/401669-Newbie-question-on-SQL-Server-2005-quotquot-string-concatenation/?CommentID=4016790http://channel9.msdn.com/401679/WebViewBug.aspx?EVT=0 Maddus Mattus wrote: Take a look at the ISNULL and the COALSESCE functions, they can help you with your problem. Thanks a lot. Thats helped me to solve the problem [H]t3ngf0ung0http://channel9.msdn.com/401679/Trackback.aspxTake a look at the ISNULL and the COALSESCE functions, they can help you with your problem.http://channel9.msdn.com/forums/TechOff/401669-Newbie-question-on-SQL-Server-2005-quotquot-string-concatenation/?CommentID=401673Tue, 06 May 2008 07:38:50 GMThttp://channel9.msdn.com/forums/TechOff/401669-Newbie-question-on-SQL-Server-2005-quotquot-string-concatenation/?CommentID=4016730http://channel9.msdn.com/401673/WebViewBug.aspx?EVT=0Take a look at the ISNULL and the COALSESCE functions, they can help you with your problem.Maddus Mattus0http://channel9.msdn.com/401673/Trackback.aspx