Playing with Patterns
The following recipes concern retrieving data when there's lots of action in the WHERE clause but the joins are simple. The four queries retrieve data by matching patterns in various ways. Read on to learn how to find
Character data when you're not sure whether it's uppercase, lowercase, or mixed
Data within a range with unknown values
Date data
Summary values based on date units
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.