COALESCE(a,'') + COALESCE(b,'')So if any of the field is NULL, it will evaluate as an empty string. That's it!
Friday, May 25, 2007
String Concatenation in SQL Server
When using '+' to concatenate two string field in SQL server (e.g. a+b), if one of them is NULL, then the whole string will become NULL. There is one solution to solve it:
So if any of the field is NULL, it will evaluate as an empty string. That's it!
So if any of the field is NULL, it will evaluate as an empty string. That's it!
Labels:
Database,
Programming,
windows
Subscribe to:
Post Comments (Atom)
CSP on Apache
To add CSP to root if sort of funny. The following will NOT work for most cases !! <LocationMatch "^/$"> Header s...
-
When Office2003 couldn't find file SKU011.CAB: regedit -> [HKEY_LOCAL_MACHINE] -> [SOFTWARE] -> [Microsoft] -> [Office] -...
-
The resolution can be changed by editing the BlueStack's registry: HKLM\SOFTWARE\BlueStacks\Guests\Android\FrameBuffer\0\Height and ...
-
Suppose you got a file in Big5 containing some HKSCS characters (e.g. 深水埗, 赤鱲角, etc). When your environment (Ref: Charset.defaultCharset( ) ...
You could also use the more intuitive:
ReplyDeleteISNULL(a, '') + ISNULL(b, '')
My Blog: http://theplague.wordpress.com/
Sir, you are a genius, and saved me from panicking all over the coming weekend.
ReplyDeleteThank you!!