Re: Case insensitive when using LIKE in SQL statement

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 Fri Aug 07 1998 - 13:33:23 CDT