Archives of the TeradataForum

Message Posted: Fri, 02 Jul 2004 @ 16:24:47 GMT

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

Hi Bill,

Try this out, dont know if it helps you .

     SELECT SUBSTRING ('265CPI0'  FROM LENGTH(TRIM('265CPI0')) -1)

TIA

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