Re: Escape sequence in Oracle SQL

You can use almost any escape character you want, like this:

..... 'INT \%HOW\%' ESCAPE '\' ..... Tim

"Nick Li" <ningli2000_at_hotmail.com> wrote in message news:bfc81ac6.0306191426.60f81616_at_posting.google.com...
> Hi,
>
> I am trying to escape the "%" character in a query. For the following
>
> select name
> from mystest
> where name like 'INT %HOW%'
>
> The two rows returned are: INT %HOW%
> INT HOW.
>
> I would like to have the query to return the row "INT %HOW%" only.
>
> I tried to use "\" escape character in the "where" clause:
> where name like 'INT \%HOW\%'
>
> but still the same two rows are returned.
>
> I would appreciate any help.
>
> Thanks.
>
> Nick
Received on Fri Jun 20 2003 - 02:03:21 CEST