H.E.L.P w TRANSLATE function

From: ZC <zuin_chn_at_my-deja.com>
Date: Tue, 14 Dec 1999 17:24:28 GMT
Message-ID: <835ug4$c42$1@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 - 11:24:28 CST