OraFAQ Forum: Server Administration » search for & in a string

Home » RDBMS Server » Server Administration » search for & in a string

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

search for & in a string [message #371402]

Fri, 13 October 2000 07:37

Steven
Messages: 13
Registered: May 1999

Junior Member

Can anyone tell me how to search for an & in a string
I assume there is an escape key but '%\&%' does not work

Thanks in advance

Steven

Report message to a moderator

Re: search for & in a string [message #371407 is a reply to message #371402]

Fri, 13 October 2000 11:38

Prem
Messages: 79
Registered: August 1998

Member

steven,

You can use something like
SELECT * FROM EMP
WHERE INSTR(ENAME , '&') > 0;

This is similar to the above requirement. If u r executing the sql from sql*plus, you can set the

SET DEFINE '~'
this will not treat & as an input character. Now if you say
SELECT * FROM EMP WHERE ENAME LIKE '%&%'

it will work

hth

Prem :)

Report message to a moderator

Re: search for & in a string [message #371417 is a reply to message #371402]

Mon, 16 October 2000 19:09

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

Try

... where mycol like '%\&%' ESCAPE '\';

In SQLplus you can also enter the command "set scan off" to avoid Oracle scanning for substitution variables.

Report message to a moderator

Previous Topic:	How to get the ipadress of the terminals connected to oracle
Next Topic:	extracting table name from variable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:43:11 CDT 2024