Archives of the TeradataForum

Message Posted: Thu, 17 Jun 2004 @ 11:55:47 GMT

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

Assuming the character string ends with the 4 digit date wanted....

     sel substr(columnname,length(columnname)-3,4)
     from tablename;

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