Archives of the TeradataForum

Message Posted: Sat, 03 Jul 2004 @ 08:35:59 GMT

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

Fair solution for going backward, but what about if you want to reverse the string?

We have the situation where we want to take a Town name and search for the last four reversed characters. For example, 'TAMWORTH' would need to be translated into 'HTRO'.

Oh yes, you can do it, but the only way I know is a bit messy, involving concatenations along with the methods already suggested. Is there a neat method?

(I bet it comes down to using a UDF - and I can't code in 'C')

Dave Clough
Database Designer

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