Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 18 May 2013 @ 20:15:31 GMT


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


Subj:   Iterate INDEX function
 
From:   Gangarevann, Prathiksha H

Hi All,

I want to iterate the functionality of INDEX-function and find the subsequent spaces if any in a string.

How do I loop this?

Note:

1. There might be one or more occurrence of space in string.

2. There might be two consequent spaces too.


Eg data-

     SEL INDEX('YX84 JHJHJ  HJH  ',' ')

Thanks in Advance,

Prathiksha



     
  <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