when using:
set ansi_nulls on
what is the best way to filter using parameters and allow for nulls:
this will not work properly:
select *
from
where [field] = @field
is there a better way than this?
select *
from
where (([field] is null and @field is null) or ([field] = @field))