Re: Ignore capitalization in Oracle 8i?
Date: 26 Dec 2001 20:53:46 GMT
Message-ID: <a0ddcq$l0p$1_at_news.netmar.com>
Hi Mike!
One possibility is to
SET SQLCASE UPPER
(or LOWER)
- Catherine Devlin http://profiles.yahoo.com/arcticturtle
In article <3c1b2a62.65954517_at_news.avnl1.nj.home.com>, <jdoe_at_nospam.com>
writes:
>What is the way to ignore capitalization when doing a query against
>Oracle? I know it can be done because we use a front end system
>(written in VB) that connects to an 8i back end has an option that
>allows you to ignore capitalization when doing a query. Which means
>there is a way to make Oracle ignore case, is it an SQL command? Is
>it a setting on the database itself?
>
>I'm writing an application that has an Access 2000 front end and an 8i
>back end and the queries appear to be case sensitive.
>
>Note: I previously posted this as "case sensitivity in a parameter
>query" but I didn't give enough information.
>
>Thank you,
>Mike
- 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