Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Name Format Change
From:   Anomy Anom

<-- 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


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023