Thread: testing for null value in integer field?

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.

-- 
Until later, Geoffrey    esoteric@3times25.net

Building secure systems inspite of Microsoft

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

select .....  where intnumber IS NULL

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.
>

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

try: column is null, as manual shows.

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.


C.