Archives of the TeradataForum

Message Posted: Wed, 17 Jul 2002 @ 14:38:12 GMT

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

If the position is constant, substring and concatenation would work, if it is in a specific column, wrap it in a case statement:

Substring (custfield from 1 for 4)|| '_' || substring (custfield from 6 for 4) || '_' ||Substring(custfield from 11 for 1)

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