thank a million to everyone replied this.
-Original Message-
Sent: Monday, October 20, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
select *
from mytable
where mycol like '\%%' escape '\'
-Original Message-
Roger Xu
Sent: Monday, October 20, 2003 4:29 PM
To: Multiple r
I think you need this instead:
select *
from mytable
where mycol like '\%%' escape '\'
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10
Roger Xu wrote:
>
> How come the following does not work
>
> select *
> from mytable
> where mycol like '\%%'
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>
Because '\' is an escape character only when explicitly declared as such
..
where myc
select *
from mytable
where mycol like '\%%' escape '\'
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an
select *
from mytable
where mycol like '\%%' escape '\'
-Original Message-
Roger Xu
Sent: Monday, October 20, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
How come the following does not work
select *
from mytable
where mycol like '\%%'
Roger Xu
Database Administrator
Dr Peppe
How come the following does not work
select *
from mytable
where mycol like '\%%'
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Roger Xu
INET: [EMAIL PROTECTED]
Fat City Network Ser