Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 09:50:00 GMT

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

Hi,

You can use substr

     substr(idcolumnname,1,(char(idcolumnname)-3))

Thanks

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