Re: [SQL] testing for null value in integer field?

[Wei Weng]

Geoffrey wrote:

How does one check for an unset value in an integer field?

I've tried such things as:

select ..... where intnumber = ''
select ...... where intnumber =  ?
select .....  where intnumber = NULL
Thanks.

It is actually WHERE intnumber IS NULL. You don't use operator = to 
compare with NULLs, you use IS.

HTH.

Wei

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings