Re: Question regardin replacing the value in a column

Praveen <nospam_at_spam.com> wrote in message news:<HpO8c.42878$GU2.38183_at_newssvr25.news.prodigy.com>...
> Hi..All,
>
> DB : Oracle 8i
>
> I have a column in a table which is of type varchar. It can contain
> characters like &, <, > etc along with all other characters.
>
> now, I want to replace them with some other characters when I select the
> column
>
> & to &amp;
> < to &lt;
> > to &gt;
>
> for eg if the column had the value <pass & fail>
>
> when I execute the SQL
> select column from table; I should get &lt;pass &amp; fail&gt;
>
> I do I write one single SQL to achieve this.
>
> Regards,
>
> P

Look in the SQL Manual at the function: REPLACE, which will replace one sub-string with another.

HTH -- Mark D Powell -- Received on Fri Mar 26 2004 - 08:22:53 CST