Re: Character string converstion

Look at the functions REPLACE or TRANSLATE. You find them in the SQL Language Reference Manual, chapter 3: operators, functions...

Hope this helps, Wolf Kammer

On Mon, 2 Dec 1996, Janus Christensen wrote:

> Hello.
>
> I have a problem with a web-enabled database containing company names
> and addresses. Whenever I try to display a company name containing a
> '&' from the database in a htp.formSubmit the '&' is displayed as an
> underscore.
>
> To get around this problem I have thought about writing a function that
> replaces all '&' with the HTML ampersand entity (&). All I need
> now is some functions to read through a string and stuff like that.
>
> However, I have some difficulty finding any reference to such functions
> in the supplied PL/SQL manuals.
>
> If there is anybody out there who has had a similar problem I would be
> grateful for your help.
>
> Regards,
> Janus Christensen
> Netkey Communication
> Denmark
>
>
Received on Mon Dec 02 1996 - 00:00:00 CET