Re: Oracle 7.0: Case insensitive string comparisons?

From: Martin Berli <berli_at_switch.ch>
Date: 7 Jan 1994 22:37:52 GMT
Message-ID: <2gko80$qjp_at_scsing.switch.ch>


Mark C. Jones (mcj_at_cccs.umn.edu) wrote:

: This is a fairly standard problems but I do not know of an Oracle solution.
 

: We have a database with a large number of names/addressess. We want to
: have the ability to do indexed lookups on these names/addresses but we
: alsow want to be able to generate nice looking mailings with the names
: capitalized correctly.

How about having two columns, one containing "MARK JONES", the other containing "Mark Jones"? Use the first one for searching, the second one for printing.

   Martin Berli


Internet: berli_at_switch.ch  | SWITCH, Swiss Academic and Research Network
Phone   : +41 1 268 1540   | Limmatquai 138
Fax     : +41 1 268 1568   | CH-8001 Zurich
Received on Fri Jan 07 1994 - 23:37:52 CET

Original text of this message