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

---

Yeah I sent this at like 8:00AM EST this morning. I figured it out

after all :P

Tim Grahl

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

From: 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]

> 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

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]

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]