Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 09:49:33 GMT

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

Hi Chanderbabu,

Try this-

     SELECT ID , substring(ID , 1,length(ID)-3) FROM table name.

Thanks & Regards

Pratima Gupta

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