Menu

Want to work with us? We're on the lookout for digital experts.

We're hiring

NULL Values in MS SQL

Web Bureau


15 January 2013 by Web Bureau

Couple of things I have come across recently with NULL values:

CONCATENATING when one field has NULL value
http://stackoverflow.com/questions/1035819/concating-null-fields

This can happen when you are building up a number of fields to compare against a search string.  Either COALESCE or ISNULL will do the trick.

WHERE COALESCE(p.field1,'') + COALESCE(p.field2,'') + COALESCE(p.field3,'') LIKE @SearchText


SQL NOT IN constraint and NULL values
http://stackoverflow.com/questions/129077/sql-not-in-constraint-and-null-values

OPPOSITE OF COALESCE
http://stackoverflow.com/a/4208280

COALESCE(field1,'') + (CASE WHEN field2 IS NULL THEN '' ELSE ' | ' + field2 END)

Grow your businessStart a project with us today.

This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.