I prefer the using the (field = @parm or @parm is null) technique to the coalesce. I seem to recall the coalesce method giving erroneous results if the field...