Database Results

G

GeoBash

How do I compare a field from a database. If the value is null the I don't want the field to display on the screen. Please help
 
K

Kathleen Anderson [MVP - FP]

GeoBash said:
How do I compare a field from a database. If the value is null the I
don't want the field to display on the screen. Please help
Click to expand...

Numeric Field Queries

Using the Is Null comparison:
SELECT * FROM Categories WHERE (CategoryID IS NULL)

Using the Is Not Null comparison:
SELECT * FROM Categories WHERE (CategoryID IS NOT NULL)

Text Field Queries

Using the Is Null comparison:
SELECT * FROM Categories WHERE (CategoryName IS NULL)

Using the Is Not Null comparison:
SELECT * FROM Categories WHERE (CategoryName IS NOT NULL)

From: http://support.microsoft.com/default.aspx?scid=kb;[LN];306430
 
Top