Advanced WHERE Clauses
Kathi Kellenberger, Scott Shaw · Apress eBooks · 2014
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, and WHERE clauses with more than two predicates and the PATINDEX function. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.