null values

[sandy1028]

Hi,

How to select name where inpacket=NULL.

select name from table where inpacket='NULL';

returns warning........

[cahva]

Dont use quotes around NULL. Actually dont check with that at all. Use:

select name from table where inpacket IS NULL

[Piranha]

And if you want values that is not null:

select name from table where inpacket IS NOT NULL