SQL Select Null values

[maxf]

Im simply trying to select all the values in my table for which there is a null value but Im unable to get the query right. Im using

Select * from orders where IsNull(status)


This isnt working. How can I do this?

thanks

 

[fluteplr]

Select * from orders where status is null

Note the syntax: is null not = null.

Nothing equals a null including another null.

 

[kutty007]

Its easy.

Select * from orders where status = NULL

 

[kutty007]

Sorry. I was not correct.
The correct syntax is IS NULL

i.e.
SELECT * FROM tblProduct WHERE Status IS NULL

 

[SemperFiDownUnda]

Just to expand
IsNull()
is a function that takes 2 parameters. The first is the value to be tested the 2nd is the value you return if the 1st IS NULL else the 1st value is returned.

status = NULL

does not work because the nature of NULL

Just like
NULL + 5 = NULL not 5

 

[iker3000]

Something to add.

Maybe you had been using Access or VB or something similar because there there is a function like ISNULL(expression) which returns TRUE if expression is NULL and FALSE in any other case (this function also can be used in querys written in access). ISNULL( ) in TRANSACT SQL is like discribed above.

Iker