PDA

View Full Version : Select records having null values


Twinkle
07-09-02, 05:14
Hey,

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

Thanx,
Twinkle

alligatorsql.com
07-09-02, 11:31
Hello,

can you use

where field IS NULL ????

Hope that helps ?

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

Sef
09-10-02, 10:47
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