Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 11:24:43 GMT

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

try this out ..

     select id,substring(id,1,lenght(id)-3) from table_name

Let me know ur comments..

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