Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 09:45:57 GMT

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

     SELECT ID, LEFT(ID, LENGTH(ID)-3) FROM MY_TABLE

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