ColdFusion Muse

Handling NULLs in MS SQL

The blog on Waterswing.com has a great entry on handling nulls in MS SQL. If you ever wondered when to use "= NULL" (if ever) and when to use "IS NULL" you should check it out. Also note the excellent tip by Barney in the comments on using the <=> operator in conjunction with CFQUERYPARAM allowing you to avoid a cumbersome CFIF statement.

0 Comments

There are no comments for this entry.

Add Comment Subscribe to Comments

Leave this field empty

Write a comment

Remember My Information:

Subscribe:

If you subscribe, any new posts to this thread will be sent to your email address.

Subscribe to Comments

Remember My Information: