SQL has an isNull function..
IsNull(ColumnName,value) as ColumnName
so the value would replace anything that would be null.
A better option would be to have the source data NOT accept nulls in that column and make the default value an empty string.
SQL has an isNull function..
IsNull(ColumnName,value) as ColumnName
so the value would replace anything that would be null.
A better option would be to have the source data NOT accept nulls in that column and make the default value an empty string.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Posting Permissions
Reply With Quote