Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to "Case Insensitive"
Real,
I think this would do it:
SELECT *
FROM mytable
WHERE UPPER(name)='FRED';
or
SELECT *
FROM mytable
WHERE LOWER(name)='fred';
Hope this helps.
"Real R. Bedard" <realb_at_helixdp.com> wrote in message
news:SG_h5.687$Z2.12800_at_nnrp1.uunet.ca...
> How do I make Oracle queries (from all users in all
> databases/schemas/tables) case insensitive.
>
> example:
> SELECT * FROM mytable WHERE name = 'fred'
> should have the same result as
> SELECT * FROM mytable WHERE name = 'FReD'
>
> similarly for ORDER BY etc.
>
> Is there a global setting for this?
>
> Your assistance is greatly appreciated.
>
> Please RSVP via e-mail
> Thanks
>
> Real R. Bedard
> realb_at_helixdp.com
>
>
>
Received on Wed Aug 02 2000 - 00:00:00 CDT