Archives of the TeradataForum
Message Posted: Wed, 21 Sep 2005 @ 18:24:44 GMT
<-- Anonymously Posted: Wednesday, September 21, 2005 14:20 -->
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 !
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|