Hi dilip,

select * from Tname

where Tcol1 = case when @X is null then null

when @X = 0 then null

else @X end

and

Tcol2 = case when @Y is null then null

when @Y = 0 then null

else @Y end

I tried this , but when i pass @x=0 it doesnt works. The Case makes it Tcol1=null.