how to align concatinated column in sql

[aamirvip]

hi,

i want to align a concatenated column.
for example:
i've 3 columns named a, b c

select a + b + c

i want to show these 3 columns in right aligned form.


plz help...

aamir

[deric]

Im not sure if I got you correctly... Could you give a sample of your expected output? Are you trying to display the result in your front-end application?

[Delerna]

As far as I know you can't do alignment in the query itself.

You will need to do the alignment in the controls of whatever frontend application you use to present the results of the query to your users with.