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 ***

[Back to original message]