Posted by decland on 09/09/05 12:10

--CELKO-- wrote:
> Pass a NULL as you flag for all rows. :
>
> SELECT <list of columns>
> FROM Foobar
> WHERE some_col = COALESCE( @parm, some_col);

What if some_col is DATETIME and NULLable?

Thanks.

[Back to original message]