Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: case insensitive "like" query in Oracle 8i??
Brad,
Well, one option is to change your WHERE to something like:
where lower(MyField) like '%program startup%'
The drawback to this is that as soon as you put that 'lower' function in there, you pretty much can kiss any usage of your index good-bye. Of course, putting that '%' at the beginning of the literal will do the same thing, so maybe you're okay. I assume that since you can't add an index, you can't add stored procedures either (since that would give you another option)?
HTH,
Roger Crowley - DBA - LearningFramework
Brad Pybus wrote:
> I would like to do a query like this in Oracle 8i:
>
> select *
> from MyTable
> where MyField like '%program startup%'
>
> But I want it to search for all the capitalization variations. In other
> words, I want it to be case insensitive. How do I do this? And I can't add
> an index because its not my database.
>
>
>
Received on Fri Jul 19 2002 - 18:55:13 CDT