Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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?


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,


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