Archives of the TeradataForum

Message Posted: Tue, 14 Mar 2006 @ 15:19:48 GMT

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

Thanks Dhanabal,

But that doesn't help me because the number of spaces isn't fixed. There can 4 words in a string, meaning 3 blanks or 10 words meaning 9 blanks and that's completely unpredictable. I therefore cannot have nested Index and Substr and concats. I hope you got what I mean here..

Thanks,

Ankit

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