null as a value

Started by Robert Campbellover 27 years ago2 messagesgeneral
Jump to latest
#1Robert Campbell
deterset@io.com

How can I select columns with null values.

select * from employee where the_date = null;

This will not work. Any suggestions ?

--
........------------========================------------........
Deterset Electronics Robert Campbell
7500 Loganberry Dr. Phone - (512) 444-1780
Austin, Tx. 78745 FAX - (512) 444-1780

#2Fandarel
fandarel@mail.solisys.com
In reply to: Robert Campbell (#1)
Re: [GENERAL] null as a value

Try:

select * from emplyee where the_date is null;

Matt

Show quoted text

How can I select columns with null values.

select * from employee where the_date = null;

This will not work. Any suggestions ?