Hi all,

Just wondering if it is possible to compare against multiple values _with_
pattern matching?

Example:

SELECT *
FROM dog
WHERE NAME LIKE 'A%Z'
OR NAME LIKE 'B___'
OR NAME LIKE '%C%'

turns into something like this

SELECT *
FROM dog
WHERE NAME IN('A%Z', 'B___', '%C%')

Of course last query won't work, but is there something like this that
doesn't need the "OR"s from the first query?

Thanks for any hints....

--
Clouds®