Archives of the TeradataForum

Message Posted: Wed, 21 Sep 2005 @ 18:24:44 GMT

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

<-- Anonymously Posted: Wednesday, September 21, 2005 14:20 -->

Hi,

I need to write a query that should search a string for all the spaces and get the position of the last space in the sting.

Eg. 'CENTURY PREFERRED OVER 65 OOA RX' has 5 spaces. I need to write a query that would get me the position of the last space which is between OOA and RX.

Any help on this would be really great !

Thanks

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