Hey,

How do I select records from SQL DB where field value is null?

Thanx,
Twinkle

Hello,

can you use

where field IS NULL ????

Hope that helps ?

Regards
Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

Hy,
I think there is nothing like "null values". Something that has a value is not NULL!


Otherwise, u can Select null records using

SELECT field1,
field2,
field3
FROM tabname
WHERE fieldx IS NULL

Note:
I am assuming that fieldx is the null field to be checked.


Nice time

Sef