[SQL] testing for null value in integer field?

[Geoffrey]

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   [EMAIL PROTECTED]
Building secure systems inspite of Microsoft

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings