hi folks,

i have a query like the one below :-


select a.amount,a.clear_memono,to_char(a.clear_memodate,' dd/mm/yyyy'),to_char(a.sancdate,'dd/mm/yyyy'),b.description
from goi a,goi_master b
where
sanc_letterno='No.15013/2180/DCH/M&E'
and sancdate=to_date('06/2003','mm/yyyy')
and a.code=b.code


i am using this as an inline query in a jsp code. due to the ampersand,the query is failing. i tried to use the replace function to eliminate the ampersand,but it didn't work.
Any suggestions folks?

thanks,
Prasen