http://www.essentialsql.com/get-ready-to-learn-sql-5-query-results-using-pattern-matching
In SQL, the Like clause is used to partially match fields. It is used in the Where condition. There are two main wildcards (% and _) which are used to create the patterns.