Re: Ampersand &

Yes that is correct .... That works great ..thanks,

Mike

Romeo Olympia wrote:
>
> I am a little confused by what you want done.
>
> Are you saying that you have values in a column that has ampersands
> '&' (eg. 'value1&', 'blah&')? And that you want to replace these with
> '&' in the query output? You're using SQLPLUS aren't you?
>
> If so, then you're having a bit of a mix-up with the default
> substitution variable &. You need to do this (in sqlplus):
>
> SET ESC \
>
> SELECT REPLACE(col1, '\&', '\&')
> FROM mytable;
>
> Or I could have gotten your question all wrong in which case this post
> probably is just another scrambled egg.
>
> Michael Hill <hillmw_at_ram.lmtas.lmco.com> wrote in message news:<40EB15C0.F0A15C7A_at_ram.lmtas.lmco.com>...
> > I have a field that has an ampersand in it: "&" that I'd like to convert
> > to "&amp;".
> >
> > I'd like to do the conversion right in the select query instead of after
> > the query returns rows and I am looping through them.
> >
> > Any ideas are appreciated.
> >
> > Mike
Received on Wed Jul 07 2004 - 10:05:26 CDT