Hello All,

Thank You all for your suggestions...

What I am looking for is when @variable is null then the condition on the col should be ignored.

I am using...

thanks Jason.. i was banging my head before i read your reply...