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