Archives of the TeradataForum

Message Posted: Fri, 27 May 2005 @ 12:27:41 GMT

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

If the field is CHAR data type (I don't know off hand if this will work with VARCHAR) you could use SUBSTRING and skip the first x characters

     i.e. SUBSTRING(STRING FROM x)

If it doesn't work with VARCHAR you could CAST the string to CHAR and then apply the SUBSTRING function

Bill H

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