Hi,

Sorry i tried, but failed to understand what u r saying...

I tried with the below query

CREATE TABLE #table1

(c1 INT, c2 INT)

INSERT INTO #table1 VALUES(1,2),(2,NULL),(3,2),(4,NULL),(5,3),(6,4)

select * from #table1 where c2<>2

As per...