Home » SQL & PL/SQL » SQL & PL/SQL » How to use % and _ in like function of where clause
How to use % and _ in like function of where clause [message #216567] Mon, 29 January 2007 07:52 Go to next message
techno
Messages: 44
Registered: October 2003
Member
Hi

I want to retrieve records having % and _ characters (not as wild card!) in one varchar2 column of a table

Pl. help me how to achieve this

Thanks in advance,
-techno
Re: How to use % and _ in like function of where clause [message #216573 is a reply to message #216567] Mon, 29 January 2007 08:07 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check here.
Previous Topic: Finding Maximum in Group Summing
Next Topic: Number Truncation in DB Link
Goto Forum:
  


Current Time: Sun Dec 04 12:50:19 CST 2016

Total time taken to generate the page: 0.04007 seconds