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

[Geoffrey]

Wei Weng wrote:
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.
Thank you muchly....

--
Until later, Geoffrey   [EMAIL PROTECTED]
Building secure systems inspite of Microsoft

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match