Escape sequence in Oracle SQL
From: Nick Li <ningli2000_at_hotmail.com>
Date: 19 Jun 2003 15:26:25 -0700
Message-ID: <bfc81ac6.0306191426.60f81616_at_posting.google.com>
Date: 19 Jun 2003 15:26:25 -0700
Message-ID: <bfc81ac6.0306191426.60f81616_at_posting.google.com>
Hi,
I am trying to escape the "%" character in a query. For the following
select name
The two rows returned are: 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.
from mystest
where name like 'INT %HOW%'
INT HOW.
Nick Received on Fri Jun 20 2003 - 00:26:25 CEST