Case insensitive when using LIKE in SQL statement

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 - 09:02:38 CDT