Good morning ye all noble software people!

When I add a "Dest_carrier" VARCHAR(3) field to a "destinations" table, that field contains nothing. As I gradually fill in values and want to display only the records in which that field is not yet filled in

> how do I spell the SQL statement < ?

Select * from destinations
where Dest_carrier = NULL doesn't do the trick

nor does
where Dest_Carrier = ''

nor does
where len(trim(Dest_Carrier)) = 0

Thank you profusely for helping me to save my week-end !

John in Belgium

where Dest_carrier is null