Query Results Using Pattern Matching

programming-transactsql

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s