I like the other option also. It has a much better chance of being optimized. I'm not sure if it will be but I'm pretty sure this version won't.

-Mike

>

WHERE ISNULL(mydatefield, '19000101') = ISNULL(@dateparm, '19000101')

>
>>

WHERE (@dateparm IS NOT NULL AND mydatefield = @dateparm)
>>   OR (@dateparm IS NULL     AND mydatefield IS NULL)

-Mike