Add Ampersand To Sql Query

I have a table of Advertisers and am trying to match data from user query string. We have advertisers, such as D&G and I am wondering how to write sql so that it is a valid se

Solution 1:

Try this :

setESCAPE \
AND (UPPER(als.SearchString) LIKEUPPER('"D\&B%"'))

Solution 2:

you can concatenate it with || or set define off

source: https://forums.oracle.com/forums/thread.jspa?threadID=466604

Solution 3:

Add ESCAPE to the end of the LIKE condition and use that character in the condition.

AND (UPPER(als.SearchString) LIKEUPPER('"D\&G%"')) ESCAPE'\'