Re: Case insensitive when using LIKE in SQL statement-not use LOWER or UPPER

I do not want to use LOWER our UPPER.

I can do that with SQL Server.

SELECT * FROM emp WHERE name like 'TOM%';

Steve Gioberti wrote in message
<6qfhm4$43s$1_at_pheidippides.axion.bt.co.uk>...
>How about:
>SELECT * FROM emp WHERE upper(name) like 'TOM%'
>Or
>SELECT * FROM emp WHERE upper(name) like upper('tom%')
>
>Joel Bergeron wrote in message <6qf1d9$cc6$1_at_news.quebectel.com>...
>>Is it possible with Oracle 7.3 to query de database without using UPPER or
>>LOWER in a query like this :
>>
>>SELECT * FROM emp WHERE name like 'tom%';
>>
>>I would like to retreive all record contening :
>>tom, TOM, tOm,... in my result.
>>
>>How it can be possible?
>>
>>
>
>
Received on Sun Aug 09 1998 - 21:18:26 CDT