Re: How to deal with needing function based indexes but stuck with St

Hello Chris,

You also can store that name as lowercase like 'scott' and always use where .. person.name like lower( v_name ) || '%' .. When you need to display it, use something like initcap( person.name ). Actually, it depends on whether you need the store exact case entered by user nor not ( ex, surname like DeSoto )..

HTH,
Michael
www.atelo.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, May 07, 2001 16:33

> Hello all,
>
> Oracle Standard Edition 8.0.5
>
> How are people handling storing data, such as a name, in the database, and
> then being able to successfully retrieve it? It's possible that the same
> name can be stored twice, such as Scott and SCOTT. Normally, I believe that
> developers would use an upper function based index on the left side of the
> WHERE equation and a UPPER function on the right side to resolve queries.
> But since this project is running Standard Edition that doesn't seem to
> address this problem.
>
> So I was curious as to what other DBAs/developers/projects are doing??
>
> TIA!!
>
> Chris
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Grabowy, Chris
> INET: cgrabowy_at_fcg.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Netrusov
  INET: mn_at_g-fax.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).