Archives of the TeradataForum

Message Posted: Fri, 02 Jul 2004 @ 16:02:29 GMT

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

I'm not sure about using a literal value, but this will work on a column name value:

     select substr(col_name,chars(trim(col_name)) ,chars(trim(col_name))-1)
     from tablename;

Fred Keiser
Highmark, Inc.
Informatics Systems Engineering (ISE)

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