Posted by ZeldorBlat on 11/17/05 04:41

How about this:

if @myparam = '' or @myparam is null
@myparam = '%'
else
@myparam = '%' + @myparam + '%'

select ...
from mytable
where MyField like @myparam

• Next in forum: Re: Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
• Prev in forum: Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
• Thread view: Re: Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL

[Reply to this message]