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