Hi all,

I have the following query which is running fine:

select *
from MyTable
where Column1 = 'A' and
Column2 = 'B' and
Column3 = 'C' and
Column4 is null and
Column5 is null and
Column6 = 3;

It returns one row. But when I convert the above into the following:

select *
from MyTable
where Column1 = 'A' and
Column2 = 'B' and
Column3 = 'C' and
Column4 = null and
Column5 = null and
Column6 = 3;

Its returning nothing. How can I make it work the second way? I actually need to pass the values for the colums through variables and place the same query into a stored procedure. How can I make this work.

Thanks