SELECT * FROM tablename WHERE column IS/IS NOT NULL

OR

SELECT *, ISNULL(column, 'NEW VALUE') as newvalue

FROM tablename WHERE column = value

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

From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf

Of Timothy Grahl

Sent: Tuesday, July 13, 2004 7:58 AM

To: ProFox Email List

Subject: [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.

Tim Grahl

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

[excessive quoting removed by server]