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,
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