Like '&'

[Saii]

how do we get data that contains '&'

Example:

select * from table
where column like 'a&b%'

This assumes &b as subsitution and asks for value. how to escape the &?

[puneetgupta03]

Hi,

Try this

set esc ' \'

select * from emp where ename like 'a\&b%' ;

[debasisdas]

Since "&" is the define character

Anything that follows & is considered as a variable

to avoid this try


set define off


then execute the query.