Link to home
Start Free TrialLog in
Avatar of pvsbandi
pvsbandiFlag for United States of America

asked on

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

ASKER CERTIFIED SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pvsbandi

ASKER

Thanks! Good idea to reverse and shrink, so it looks rotated.