& in SQL query

I have a script that looks for all jobs that contain a particular calendar.

Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this?

I have tried:

select job_name from job where run_calendar='1&15dom'
select job_name from job where run_calendar='1\&15dom'

Any help is much appreciated...

Linda

Which database is it? MySQL does not seem to have this problem.

Are you running this in SQL Plus. & is a substitution variable in Oracle. The only way to prevent substitution in SQL Plus is by setting define off.

Run SET DEFINE OFF before running the SQL command

Thanks!

I did a "set escape \" in sqlplus and then I was able to backslash the literal...