SELECT * FROM
WHERE [Column]=Null
How I can do the equivalent of the above statement in SQL? I can do:
SELECT * FROM
WHERE [Column]="Value"
which returns the correct rows, but
SELECT * FROM
WHERE [Column]=""
.. OR ..
SELECT * FROM
WHERE [Column]=Null
both return nothing, even though I know some of the rows in the table contain Null in the appropriate column.
Any pointers or suggestions would be really apreciated.
Yours,
James
How I can do the equivalent of the above statement in SQL? I can do:
SELECT * FROM
which returns the correct rows, but
SELECT * FROM
.. OR ..
SELECT * FROM
both return nothing, even though I know some of the rows in the table contain Null in the appropriate column.
Any pointers or suggestions would be really apreciated.
Yours,
James