If "Select salary from Employee" returns the following: 120000 70000 95000
How can I get the numbers to line up RIGHT JUSTIFIED?
Quick SQL Question
Aug 17, 2007
2 Replies
You can't format the results of a query without exporting them and using some other application. File | Export...
Tom
Try this one
select right(replicate(' ', 12) + salary, 12) from employee
"Lum> If "Select salary from Employee" returns the following:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required