Обсуждение: 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.