The use of wildcard character searches in SQL Server scripts is common for all of us. This article makes some good points on how to do it correctly and what to avoid.

Please read this article. It may help you better understand your options when it comes to string searches.

http://www.sqlservercentral.com/articles/T-SQL/130558/?utm_source=SSC&utm_medium=pubemail