Archives of the TeradataForum

Message Posted: Sat, 13 Mar 2010 @ 10:05:03 GMT

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

Hi,

Please let me know how to find the nth or last position of space in a string .

For example, if I use sel position(' ' in 'Arul D joseph') , I will get 5 as the position, but I want to get the second or last position of blank space in this string. How I can get this?

Thanks & Regards,

Arul

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