Right Alignment in SQL

Hi all,
By default all the values in the result set are left aligned. But
I want to align a column in a result set of a query to right side...
Is it possible in SQL?
Example:
Charges
11145.00
171.00
26.00
6.00
Result should be
Charges
11145.00
171.00
26.00
6.00
Please advise
Thanks,
Souraselect str(charges,10,2) from tb
-oj
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:AFB802C8-4C26-43CA-A1A4-3F9AF28EF8EB@.microsoft.com...
> Hi all,
> By default all the values in the result set are left aligned. But
> I want to align a column in a result set of a query to right side...
> Is it possible in SQL?
> Example:
> Charges
> 11145.00
> 171.00
> 26.00
> 6.00
> Result should be
> Charges
> 11145.00
> 171.00
> 26.00
> 6.00
> Please advise
> Thanks,
> Soura|||Hi
This is really dependent on the client tool, for example SQL Server
Management studio has an option to right align numeric values in the results
to text option settings.
John
"SouRa" wrote:

> Hi all,
> By default all the values in the result set are left aligned. But
> I want to align a column in a result set of a query to right side...
> Is it possible in SQL?
> Example:
> Charges
> 11145.00
> 171.00
> 26.00
> 6.00
> Result should be
> Charges
> 11145.00
> 171.00
> 26.00
> 6.00
> Please advise
> Thanks,
> Soura