Re: Querying for Strings with containing Wildcards

Hulk wrote:

> Hey guys,
>
> I was wondering if I could get a hint on querying for strings containing a
> wildcard, notable the % sign. Against our advice one our clients has
> created many values in their database containing percent signs and would now
> like a list of the appropriate records so they can delete them.
>
> Obviously the following does not work,
>
> select field from table where field = 'xx%'
>
> I tried the following
>
> set escape \
>
> select field from table
>
> where field = 'xx\%';
>
> This kinda worked excpet it does not seem to allow us to search for any and
> all records containing a percent sign.
>
> Any tips of advice would be appreciated.

Try the following SQL

select ascii('%') from dual;

I think it will lead you in a direction that will work.

Daniel Morgan Received on Mon Nov 11 2002 - 14:58:19 CST