S_Kumar_S (9/24/2012)

---

Hi

Here is sample script:

create table a(id int, nm varchar(200))

insert into a

select 1,'a'

insert into a

select 1,NULL

select * from a where nm not in('a')

I logically expect NULL records to be returned here, but they are not. What can be the alternative way to fetch the NULL records. Yes, I can add condition " OR a IS NULL' but why should I load my where caluse for a very logical requirement? Is their some setting which impacts this behavior?