Archives of the TeradataForum

Message Posted: Fri, 04 Dec 2009 @ 16:06:13 GMT

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

Paul - Your best bet is probably to use a User Defined Function for this purpose. There are UDF's available for download on Teradata.com which does exactly what you need. We use the 'Translate' and 'Replace' functions quite frequently.

Johannes de Wet
Unum

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