Re: Find % in where like statement

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                                                  *
*    *    *    *    *    *    *    *    *    *    *    *    *    *    *    *