"Not In" 1

[dndaughtery]

I need to write a query which returns all records that don't have a 602 or 610 in a field called subserviceID. This is what I currently have:


SELECT * From rejects where SubServiceID Not In (602, 610)


But it returns no rows. I have checked the table and the majority of the records have a null value which I'd like to have reurned. What am I doing wrong?

 

[fredericofonseca]

select * from rejects where isnull(subserviceid,0) not in (602,610)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[dndaughtery]

Thanks a bunch