Posted by --CELKO-- on 09/06/05 16:07

Pass a NULL as you flag for all rows. :

SELECT <list of columns>
FROM Foobar
WHERE some_col = COALESCE( @parm, some_col);

• Next in forum: JDBC deadlock on unrelated records
• Prev in forum: Re: Massive delete in DB
• Thread view: Re: select * from table where column = @AllValues?

[Reply to this message]