Re: - H.E.L.P w TRANSLATE function

Hello,

You could try this

select replace('It is JULY', 'JULY', 'AUGUST') from dual;

Wim

ZC <zuin_chn_at_my-deja.com> wrote in article <835ui9$c61$1_at_nnrp1.deja.com>...
> If there is an existing record in a database, for example: JULY
> How would you chage it to AUGUST without having to delete the entire
> row.
>
> I'm trying this, but I'm not getting any luck. JUNE is in a column
> called month.
>
> Should i put COLUMN like this? TRANSLATE(column('AUGUST'
>
>
> SELECT TRANSLATE('AUGUST', 'ABCDEFGHIJKLMONOQRSTUVWXYZ'
> 'ABCDEFGHIJKLMONOQRSTUVWXYZ')
> from customer
> where cust_code = '99078';
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Tue Dec 14 1999 - 13:27:39 CST