Thanks though.

Tim Grahl

-----Original Message-----

From: Derek J. Kalweit [mailto:dkalweit@sensiblesoftware.com]

Sent: Tuesday, July 13, 2004 2:04 PM

To: ProFox Email List

Subject: RE: [NF] Checking for NULL with Transact SQL

> 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

[excessive quoting removed by server]