Re: testing for null value in integer field?

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    esoteric@3times25.net

Building secure systems inspite of Microsoft