membership operator with pattern matching

From: (wrong string) ® <DOCloudsNOT_at_hardwareSPAM-spot.com>
Date: Wed, 20 Oct 2004 09:32:30 +0200
Message-ID: <4176148e$0$559$e4fe514c_at_news.xs4all.nl>



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®
Received on Wed Oct 20 2004 - 09:32:30 CEST

Original text of this message