Re: Another query question..
From: <catherinedevlin_at_removethispart.toast.net>
Date: 27 Feb 2002 20:45:03 GMT
Message-ID: <a5jggf$bmb$1_at_news.netmar.com>
Date: 27 Feb 2002 20:45:03 GMT
Message-ID: <a5jggf$bmb$1_at_news.netmar.com>
In article <l4cg7uotc0c5q6pn85q6t44l7ea2p9j0em_at_4ax.com>,
<jkuteynospam_at_nycap.rr.com> writes:
>How would I write the query from this statement...
>
>Select the item and item price of all items that start with S, P or F.
>
WHERE substr(item,1,1) IN ('S','P','F')
or use brute force with ORs...
WHERE item LIKE 'S%'
OR item LIKE 'P%'...
Or, if you really want to show off,
WHERE translate(item,'PF','SS') LIKE 'S%' will change your Ps and Fs into Ss so that the LIKE clause will work.
- Catherine Devlin
profiles.yahoo.com/arcticturtle
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net