how to reterieve records with """
Hi,
I am trying to reterieve records where """ exists in data, and replace this with single quote. i have used the following queries but it does not work.
select idx,source,OFF_NAME,OFF_NAME_FORM, WEBSITE_FORM
from TT
where OFF_name_FORM like '%' || chr(38) || 'QUOT'
select idx,source,OFF_NAME,OFF_NAME_FORM, WEBSITE_FORM
from TT
where OFF_name_FORM like '%' || '&' || 'QUOT'
can anybody let me know how to get the required output.
Thanks