In Chapter 3, you learned how to write queries with SELECT, FROM, WHERE, and ORDER BY clauses. Chapter 3 covered a lot of options for filtering results with the WHERE clause; however, there is still more to learn. This chapter will discuss using the comparison operator LIKE and matching against a partial value or a pattern, full-text search, WHERE clauses with more than two predicates, and the PATINDEX function.
Pattern Matching
Sometimes, you know only part of the value that will match the data stored in the table. For ...
