Archives of the TeradataForum

Message Posted: Mon, 05 May 2003 @ 17:21:45 GMT

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

Thanks to all,

substr(:IN_VALUE, 1,5) || substring(:IN_VALUE, 7, 6)

worked great! I originally left out the ':'.

Nick

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