Re: testing for null value in integer field?

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