ColdFusion Muse

Handling NULLs in MS SQL

Mark Kruger October 28, 2005 12:05 PM MS SQL Server Comments (0)

The blog on 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.

  • Share: