Archives of the TeradataForum

Message Posted: Thu, 14 Apr 2016 @ 13:11:41 GMT

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

Hi Dave,

Using OTRANSLATE might do the trick, you only need the complete list of possible special characters:

     SEL
     txt_latin,
     OTRANSLATE (LOWER(txt_latin), '',
     'aaaaceeeeiiooouuuy') AS c1,
     txt_unicode,
     OTRANSLATE (LOWER(txt_unicode), '',
     'aaaaceeeeiiooouuuy') AS c2
     FROM tb
     ;

If your columns are case sensitive, you might need to use "lower" as well.

Regards,

Tomas Gorner

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