Re: Oracle 7.0: Case insensitive string comparisons?
From: Peter Kane <pkane_at_cisco.com>
Date: 7 Jan 1994 23:31:25 GMT
Message-ID: <2gkrcd$9pm_at_cronkite.cisco.com>
Date: 7 Jan 1994 23:31:25 GMT
Message-ID: <2gkrcd$9pm_at_cronkite.cisco.com>
How about storing the name fields as received (deVere would stay deVere) but do all comparisons and searches on upper-case shifted fields?
The where clause you would use in comparison would be:
where upper(name) like '%DEVERE%'
?
Peter
pkane_at_cisco.com
Received on Sat Jan 08 1994 - 00:31:25 CET