>Thanks Sergey,
>
>I was afraid of that. We have >4million titles on file and "[title] like'%'+ rtrin(@searchstring)+'%''" can be pretty slow for a web store application. Maybe if I get a little "inventive" with indexing parts of the title string we can kick it up a little.
>
>Glenn
>
Can you first search for the beginning of it, e.g. Title like rtrim(@SearchString) + '%' and then try UNION with the rest? I remember reading somewhere that it may yield better performance.
If it's not broken, fix it until it is.
My Blog