SQL Null values and non-Null values
I have a table that looks like this:

- ID (pk,int)
- Col1 (nvarchar)
- Col2 (nvarchar)
- Col3 (nvarchar)

In all columns (except ID) some values are NULL.

I want to make a query that will look like this:

SELECT * FROM Table 
WHERE (Col1=<parameter> AND Col1 IS NULL)
 +    (Col2=<parameter> AND Col2 IS NULL)
etc.

I need values that are NULL and that are equal to parameter


Thanks
SQL Null values and non-Null values
===

I have a table that looks like this:

- ID (pk,int)
- Col1 (nvarchar)
- Col2 (nvarchar)
- Col3 (nvarchar)

In all columns (except ID) some values are NULL.

I want to make a query that will look like this:

SELECT * FROM Table 
WHERE (Col1=<parameter> AND Col1 IS NULL)
 +    (Col2=<parameter> AND Col2 IS NULL)
etc.

I need values that are NULL and that are equal to parameter


Thanks