Archives of the TeradataForum

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

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

I think below one will work.

     SUBSTR(COL_NAME,1,CHAR_LENGTH(COL_NAME)-3)

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