First question to pose is: Shoud that column have nulls ?
Second question to pose is: wouldn't a default empty varchar do the same trick ? If so modify the data model so the column is Not-Nullable and put an empty string in all occurences that are nulled.
If you cannot avoid NULLs, your applications will have to deal with that every time !
your TSQL options are
Isnull( yourcolumn, 'replacementvalue' )
Isnull( yourcolumn, othercolumn ) -- <-- may still return NULL if othercolumn is also nullable
Coalesce( yourcolumn, othercolumn, ..., 'replacementvalue')
check books online for details !
When using concatenation, keep in mind you also need to translate the columns to a common data type.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me