How to rotate the text to 90 degrees?

Hi,

 I'm on DB2 UDB 9.7.
I need to display some text to rotate to 90 degrees.
If this can be done in straight SQL (not involving any CTE), then that would be helpful.
Because, the tool we are using doesn't support CTEs.

Thank you!

Example:
If the text is : Department, then we need to display the text as:

T
N
E
M
T
R
A
P
E
D

Open in new window

pvsbandiAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Tomas Helgi JohannssonConnect With a Mentor Commented:
Hi!

This solution shows some good reverse function and/or reqursive sql.
http://www.experts-exchange.com/Database/DB2/Q_27521882.html

This can then be use to do a simple substr(mystring,thepos,1) on the reversed string.
Best solution would be to create a function that has string as a input and outputs a resultset with the string reversed and cut into character, row by row.

Regards,
    Tomas Helgi
0
 
pvsbandiAuthor Commented:
Thanks! Good idea to reverse and shrink, so it looks rotated.
0
All Courses

From novice to tech pro — start learning today.