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

How about...

update table set month = 'AUGUST' where month = 'JUNE'

?

Translate does an alternate character mapping - I don't think that's what you're after here.

HTH,
-Jeff

On Tue, 14 Dec 1999 17:24:28 GMT, ZC <zuin_chn_at_my-deja.com> wrote:

>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:12:01 CST