Re: [SQL] testing for null value in integer field?

[Guy Fraser]

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.



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]