Selecting NULL

Hi,

i need to perform some searching on 10 columns. Since it will return >1 records/lines, i need to filter, if @param1 match with col1, then abandon those Null value in column1 set, and find match @param2 to col1.
@param1='SS',
@param2='' (if '' i set to %)
til 10

Find matching columns:
Row1 : Col1='SS' (matched) Col2=NULL Col3='bb
Row2 : Col1='SS' (matched) Col2='abc' Col3=NULL
Row3 : Col1=NULL (unmatched) Col2='huh'(matched)

problem is when i want to search only if colX is 'something', it returns null value,.. my where clause

WHERE
(d.RecvUDF1 LIKE @UDF1 OR d.RecvUDF1 IS NULL) AND(d.RecvUDF2 LIKE @UDF2 OR d.RecvUDF2 IS NULL) AND(d.RecvUDF3 LIKE @UDF3 OR d.RecvUDF3 IS NULL) AND(d.RecvUDF4 LIKE @UDF4 OR d.RecvUDF4 IS NULL) AND(d.RecvUDF5 LIKE @UDF5 OR d.RecvUDF5 IS NULL ) AND(d.RecvUDF6 LIKE @UDF6 OR d.RecvUDF6 IS NULL) AND(d.RecvUDF7 LIKE @UDF7 OR d.RecvUDF7 IS NULL ) AND(d.RecvUDF8 LIKE @UDF8 OR d.RecvUDF8 IS NULL) AND(d.RecvUDF9 LIKE @UDF9 OR d.RecvUDF9 IS NULL) AND(d.RecvUDF10 LIKE @UDF10 OR d.RecvUDF10 IS NULL )

-i wrote the OR NULL is because i need those nulls value when im not searching for that column..
-i replace '' to '%' because i need to list any other remaining unmatched columns when i found the matching column.

maybe it's quite ridiculous to understand my Q ...coz i couldnt find any other better way to explain
thanks in advance


~~~Focus on problem, not solution~~~