 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / March 2008SQL Server string concatenation
Hi all, I have a small problem... I need to do string concatenation in sql server... i.e. select field1 + field2 + field3 as JoinedField from table This works fine IF all the fields have content, but if one of them is null, then the whole JoinedField is null. Any idea on how I can fix it? I want the joined value as though the null was just an empty string. Thanks.  SignatureBest regards, Dave Colliver. http://www.AshfieldFOCUS.com ~~ http://www.FOCUSPortals.com - Local franchises available Yeah IsNull( field1, WhatYouWantGoesHere ) > Hi all, > [quoted text clipped - 13 lines] > > Thanks. Cool, thank you. That works great... SignatureBest regards, Dave Colliver. http://www.AshfieldFOCUS.com ~~ http://www.FOCUSPortals.com - Local franchises available > Yeah > [quoted text clipped - 17 lines] >> >> Thanks. select CASE WHEN field1 is null then '' ELSE field1 END + CASE WHEN field2 is null then '' ELSE field2 END + CASE WHEN field3 is null then '' ELSE field3 END AS JoinedField SignatureGregory A. Beamer MVP, MCP: +I, SE, SD, DBA Subscribe to my blog http://gregorybeamer.spaces.live.com/lists/feed.rss or just read it: http://gregorybeamer.spaces.live.com/ ************************************************* | Think outside the box! ************************************************* > Hi all, > [quoted text clipped - 13 lines] > > Thanks. And a 3rd version (all 3 would work fine): Select Coalesce(field1, '') + coalesce(field2, '') etc. > select > CASE WHEN field1 is null then '' [quoted text clipped - 25 lines] >> >> Thanks.
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.