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)
Upgrade nodejs in conda (from v18 to v26)
If your conda env is nodejs v18, doing a conda install nodejs=26 is likely to create a lot of conflict. Consider remove those conflicting p...
-
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!!