Archives of the TeradataForum

Message Posted: Fri, 21 Sep 2007 @ 15:49:52 GMT

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

<-- Anonymously Posted: Friday, September 21, 2007 09:42 -->

Looking for a way using SQL alone to transform the names from the below volatile table to be "last, middle, first" instead of "first middle last".

So if you load this volatile:

     create volatile table vol
     (R_Name VARCHAR(42))
     primary index (r_name)
     on commit preserve rows
     ;
     insert into vol sel 'Scott S Smith';
     insert into vol sel 'Mike K. Carter';
     insert into vol sel 'Sam Simpson';

What I want to be able to do is select from it, and have it output this:

     Carter, Mike K.
     Smoth, Scott S
     Simpson, Sam

Thanks

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