OraFAQ Forum: SQL & PL/SQL » How can i find the % in some of string by like option and

Home » SQL & PL/SQL » SQL & PL/SQL » How can i find the % in some of string by like option and

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can i find the % in some of string by like option and [message #21618]

Sun, 18 August 2002 23:25

HAB
Messages: 3
Registered: July 2001

Junior Member

Hi,
i have some of strings. it's content % sign.
how can i finde the only string content % sign by using like option and by using anther method.?!

Report message to a moderator

Re: How can i find the % in some of string by like option and [message #21623 is a reply to message #21618]

Mon, 19 August 2002 06:28

inna
Messages: 6
Registered: July 2002

Junior Member

create table test (COL1 varchar2(10));
insert into test values ('ABC%');
insert into test values ('%DE');
insert into test values ('FG%HI');
COMMIT;
SELECT * FROM TEST
WHERE COL1 LIKE '%%%' ESCAPE '';

Report message to a moderator

Previous Topic:	Triggers
Next Topic:	decode help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 08:16:45 CDT 2024