membership operator with pattern matching

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Ū