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>
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 ZurichReceived on Fri Jan 07 1994 - 23:37:52 CET