My friend Victoria Yudin has posted a great introductory article on her blog about how to use the LIKE command in where clauses when creating queries on SQL Server.
Even if you know your Transact-SQL, it is always good to get a refresher.
Have a look at Searching for strings in SQL Server using LIKE for more information.
David
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.