Re: Find % in where like statement

Pete and Paul,

There is a way of doing this - you can specify the escape character at the end of the LIKE clause, e.g.:

select * from account_data
where increase like '%+%%' escape '+';

Paul

(sorry, I really do try to not answer my own posts - just came across this one in dejanews :-).

Paul Wagner <wagner_at_cs.umn.edu> wrote:
>I can't find any way of escaping the % in a LIKE string so that it's
>not considered just another wild card marker. If anyone else knows
>if there's a way of doing this, please post.
>
>An office mate notes that you can do what you need with INSTR; e.g.
>
>select *
>from account_data
>where INSTR(increase, '%') > 0;
>
>Paul
>
>---
>
>Pete Cruz <petec_at_eden.com> wrote:
>>How would query a table using the like and look for a % value?
>>
>>Select *
>>from account_data
>>where increase like '% % %';

--

*    *    *    *    *    *    *    *    *    *    *    *    *    *    *    *
* Paul J. Wagner                School   - wagner_at_cs.umn.edu               *
* Computer Science Department   Work     - wagnerp_at_uwstout.edu             *
* University of Minnesota                                                  *
*    *    *    *    *    *    *    *    *    *    *    *    *    *    *    *