This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on http://www.winthropdc.com/blog.