ruediger magnet schrieb in Nachricht ...
>> Hi ALL!>> I have the problem with CASE SENSITIVE data-queries. For
>example,
>> when i give my request:
>> SELECT * FROM table_name WHERE column1 LIKE 'value1'>
>> This request gives results different from the ones given by the request:>
>> SELECT * FROM table_name WHERE column1 LIKE 'Value1'>
>> The well-known solution to solve CASE SENSITIVE is to use UPPER:
>> SELECT * FROM table_name WHERE UPPER(column1) LIKE UPPER('value1')>
>
>> But i would like to know how to configure ORACLE so that we don't need
>> to user> the operator UPPER in requests.>> Thank for help.>> -------
>> Rudolf Fuhlroth
>
>
Received on Sun Aug 30 1998 - 10:05:15 CDT
