MSSQL: Concatenate a string with a NULL value
If the above scenarios occurs, the resulting output would be NULL/empty. To remedy such issue, ISNULL function can be used to replace the NULL value to an empty string like below:
ISNULL(fieldName,”)
Written by admin on March 10th, 2010 with no comments.
Read more articles on Knowledge Base and Programming.