Archives of the TeradataForum

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

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

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