Archives of the TeradataForum

Message Posted: Fri, 08 Dec 2006 @ 21:47:31 GMT

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

Hi Prahlad:

Regardless of how you are going to handle the number of digits less than 4, given the variable length of the digits, the simpliest technique is to substring from the 4th position after trimming the leading spaces from your numeric data.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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