RE: [NF] Checking for NULL with Transact SQL

Author: Derek J. Kalweit

Posted: 2004-07-13 at 13:04:09

> I am using SQL Server 2000 and need to check for NULL. i.e. SELECT *

> FROM tablename WHERE column = NULL

>

> How is this accomplished? Thanks.

SELECT * FROM tablename WHERE column IS NULL;

--

Derek

©2004 Derek J. Kalweit