Archives of the TeradataForum

Message Posted: Fri, 02 Jul 2004 @ 16:07:34 GMT

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

Yes, it does work on a literal:

     select substr('265CPI0',chars(trim('265CPi0')) ,chars(trim('265CPI0'))-1)

Fred Keiser

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