Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Sep 2005 @ 18:24:44 GMT


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


Subj:   Query to get the last space in a string.
 
From:   Anomy.Anom

<-- Anonymously Posted: Wednesday, September 21, 2005 14:20 -->

Hi,

I need to write a query that should search a string for all the spaces and get the position of the last space in the sting.

Eg. 'CENTURY PREFERRED OVER 65 OOA RX' has 5 spaces. I need to write a query that would get me the position of the last space which is between OOA and RX.

Any help on this would be really great !


Thanks



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