Re: Oracle 7.0: Case insensitive string comparisons?

From: Dagmar A. Bogan <dagmar_at_indian.mitre.org>
Date: 10 Jan 1994 13:04:42 GMT
Message-ID: <2grjpa$ips_at_linus.mitre.org>

Few suggestions:

1. Use: UPPER(column_value) = UPPER(search_text)...problem: this will disable the indices
2. Have two columns, an UPPER value and mixed cap value, with an index on each
3. To create the nice looking mailing labels, if the label is 45 characters wide:

    lpad(name,45)||
    lpad(addr_line1,45)||
    lpad(addr_line2,45)||
    lpad(city||', '||state||'  '||zip_code  address

    If you are storing the text values in upper case, then use:

    lpad(initcap(name),45)||

good luck! Dagmar

---

The opinions expressed herein do not necessarily reflect those of The MITRE Corporation.

---

---

Dagmar Anne Bogan                     *
Software Engineering Center           *
The MITRE Corporation                 * phone: 703.883.6093
M/S Z676                              * fax:   703.883.6991
7525 Colshire Drive                   * email: dagmar_at_indian.mitre.org
McLean, Virginia  22102-3481          *


******************************************************************************

Received on Mon Jan 10 1994 - 14:04:42 CET