In a recent blog article by Kris Wenzel, he talks about getting specific results in your query using pattern matching:
In this lesson you are going to explore how to do pattern matching with the SQL Where clause LIKE operator. Using this phrase allows us perform partial matches of data values and obtain answers to questions which can’t be done with conventional comparisons.
The lesson’s objectives are to:
learn about the like clause
understand wild cards
Once you have gone through the lesson, please be sure to do the exercises. These and the examples that follow are based on the sample database. Be sure to get a copy so you can follow along.
This interesting article explains how you could use specific patterns to help match specific records in your queries.