Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 13 Mar 2010 @ 10:05:03 GMT


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


Subj:   Find the position of 'n'th space (blank) in a
 
From:   Arul Joseph Daniel

Hi,

Please let me know how to find the nth or last position of space in a string .

For example, if I use sel position(' ' in 'Arul D joseph') , I will get 5 as the position, but I want to get the second or last position of blank space in this string. How I can get this?


Thanks & Regards,

Arul



     
  <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