Multiple LIKE clauses in a single WHERE statement

[James Beresford]

I recently came up against a scenario where, in amongst a number of other filters, I had to deal with a couple of wildcard criteria. As there is no option to have multiple LIKE clauses in native SQL, such as WHERE Field LIKE IN (’%Option1%’,'%Option2%’), I feared I was stuck with having to duplicate my WHERE clause in its entirety for each LIKE operation – until I found this cunning bit of code (from the thread here):

/* Apply Multiple LIKE clauses in a single WHERE clause */
SELECT**
*
FROM*[AdventureWorks].[Person].[Contact]
*
WHERE*CASE
**WHEN FirstName LIKE‘Gusta%’ THEN 1
**WHEN FirstName LIKE ‘Cath%’ THEN 1
**END = 1

An*elegant solution!



Get More from the original blog...