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.

Related articles

No comments

There are still no comments on this article.

Leave your comment...

If you want to leave your comment on this article, simply fill out the next form:




You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> .