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

Joel,

        Unfortunately Oracle isn't perfect and it is not a superset of all of the features found in every RDBMS. If you really don't want to use UPPER or LOWER you will have to go back to SQL Server.

regards

Jerry

Joel Bergeron wrote:
>
> 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?
> >>
> >>
> >
> >

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group