Archives of the TeradataForum

Message Posted: Tue, 14 Sep 2004 @ 16:20:14 GMT

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

Hi David:

There is no need to do what you ask about in a UDF. Regular SQL using a SUBSTRING and CHAR can accomplish the reversal. If you don't like using straight SQL, you could write a stored procedure to accomplish it as well using the length as your control on the looping activity.

I don't like writing C programs either.

Hope this helps point you in a better direction,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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