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.

• Next in forum: Re: select * from table where column = @AllValues?
• Prev in forum: Re: Creating Text File from Stored Procedure
• Thread view: Re: select * from table where column = @AllValues?

[Reply to this message]