Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Kathi Kellenberger
About this chapter
Cite this chapter
Kellenberger, K., Shaw, S. (2014). Advanced WHERE Clauses. In: Beginning T-SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0046-9_9
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0046-9_9
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0047-6
Online ISBN: 978-1-4842-0046-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books