Skip to Main Content
Beginning T-SQL
book

Beginning T-SQL

by Kathi Kellenberger, Scott Shaw
August 2014
Beginner content levelBeginner
496 pages
12h 26m
English
Apress
Content preview from Beginning T-SQL

CHAPTER 9

image

Advanced WHERE Clauses

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.

Pattern Matching

Sometimes you know only part of the value that will match the data stored in the table. For example, you may need to search for one word within a description. You can perform searches ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

T-SQL Fundamentals, 4th Edition

T-SQL Fundamentals, 4th Edition

Itzik Ben-Gan
Learning SQL

Learning SQL

Ben Forta

Publisher Resources

ISBN: 9781484200469Purchase book