Posted by Rakesh Makhijani on 09/09/05 12:51

Misunderstood ur question


some_col = COALESCE( @parm, some_col)

or

@parm IS NULL OR some_col = @parm

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: Immediate Synchronization?
• Prev in forum: Re: select * from table where column = @AllValues?
• Thread view: Re: select * from table where column = @AllValues?

[Reply to this message]