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

[Back to original message]