Archives of the TeradataForum

Message Posted: Fri, 08 Dec 2006 @ 21:51:00 GMT

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

Well, if you want to stay numeric and pick out digits from the left:

     ((c1 / (10**((log(c1)(integer))-3))) mod 10) (integer)

String conversion might be cheaper - you'd have to test.

/dave hough

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