Archives of the TeradataForum

Message Posted: Tue, 19 Aug 2003 @ 09:23:29 GMT

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

Try using the following

sel trim(substr(COLNAME,8,length(COLNAME))) from TABLENAME;

This returns the record from position 8 to the end of the record, and both leading and trailing spaces are trimmed.

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