string transformation

[cgj]

I am looking to manipulate a string through that is used in a stored procedure so that it is inverted (eg abcdef becomes cdbeaf). Is there a SQL string function to tranform the string in this way?

Thanks!
cgj

 

[tlbroadbent]

Yes!

Select Reverse(col1) As RevCol1 Terry

;-) I never worry about the future. It comes soon enough. -Albert Einstein

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[cgj]

But doesn't that just literally reverse the string and not invert it?
Thanks for your help!

 

[tlbroadbent]

Sorry, I didn't read your example carefully enough. The only definition of "inverse string" that I've seen is "the original string read backwards" which REVERSE does.

I'm unaware of any function that does what you want. What is the algorithm? You should be able to write a function or T-SQL code if the algorithm is known. Terry

;-) I never worry about the future. It comes soon enough. -Albert Einstein

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm