Archives of the TeradataForum

Message Posted: Wed, 17 Dec 2008 @ 21:10:47 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Wed, 17 Dec 2008 15:43 -->

Hi all,

I need a function who replace a caracter series by another one, I need a equivalent function than TRANSLATE() in Oracle.

     By exemple : Select TRANSLATE('S�bastien Cr�te No�l','�, �, �, �, �, �','e,e,e,E,E,E') from dual;
                                         => answer : 'Sebastien Crete Noel'

I asked my question in french, because the problem is about frenc language accent.

J'ai besoin d'une fonction qui remplace une s�rie de caract�res par une autre, donc un �quivalent de la fonction TRANSLATE() d'Oracle.

     Exemple : Sous Oracle => Requ�te : Select TRANSLATE('S�bastien Cr�te No�l','�, �, �, �, �, �','e,e,e,E,E,E') from dual;
                                         => R�sultat : 'Sebastien Crete Noel'

                     Sous Teradata => ?

Merci

	<Prev	Next>		<<First	<Prev	Next>	Last>>