Quick SQL Question

- L
- Luminox
  
  Contact options for registered users
posted
16 years ago

Fri, Aug 17, 2007 12:50 AM

If "Select salary from Employee" returns the following: 120000 70000 95000

How can I get the numbers to line up RIGHT JUSTIFIED?

Loading thread data ...

- T
- Terrible Tom
  
  Contact options for registered users
Vote on answer
posted
16 years ago

Fri, Aug 17, 2007 1:10 AM

You can't format the results of a query without exporting them and using some other application. File | Export...

Tom

- R
- Rodney
  
  Contact options for registered users
Vote on answer
posted
16 years ago

Fri, Aug 17, 2007 5:58 AM

Try this one

select right(replicate(' ', 12) + salary, 12) from employee

"Lum> If "Select salary from Employee" returns the following:

XML Sitemap
Terms of Service
Privacy Policy
Contact

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.