By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

how to align concatinated column in sql

P: 7
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
Apr 9 '08 #1
Share this Question
Share on Google+
2 Replies


P: 92
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?
Apr 10 '08 #2

Delerna
Expert 100+
P: 1,134
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.
Apr 10 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.