Home » SQL & PL/SQL » SQL & PL/SQL » How to fetch % symbol using like operator
How to fetch % symbol using like operator [message #272782] Sun, 07 October 2007 06:14 Go to next message
admurthi
Messages: 7
Registered: September 2007
Junior Member

Hi all,

IF a columnn contain data like 100%, 200%, 300%

How to fetch these data using LIKE operator

Tanks in adv

Re: How to fetch % symbol using like operator [message #272787 is a reply to message #272782] Sun, 07 October 2007 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use escape.
LIKE

Regards
Michel
icon10.gif  Re: How to fetch % symbol using like operator [message #272805 is a reply to message #272787] Sun, 07 October 2007 12:12 Go to previous messageGo to next message
admurthi
Messages: 7
Registered: September 2007
Junior Member

I tried tht,
Tanq michel

[Updated on: Sun, 07 October 2007 12:12]

Report message to a moderator

Re: How to fetch % symbol using like operator [message #272896 is a reply to message #272805] Mon, 08 October 2007 02:26 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
And did it work?

If not, show us (cut and paste from SQL*Plus ideally) what you did and we'll show you what went wrong.
Previous Topic: Converting Blob to Clob
Next Topic: ORA-02070: database does not support operator PLSFUN in this context
Goto Forum:
  


Current Time: Thu Dec 08 10:05:01 CST 2016

Total time taken to generate the page: 0.14717 seconds