how to align concatinated column in sql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aamirvip
    New Member
    • Feb 2008
    • 7

    how to align concatinated column in sql

    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
    New Member
    • Dec 2007
    • 92

    #2
    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?

    Comment

    • Delerna
      Recognized Expert Top Contributor
      • Jan 2008
      • 1134

      #3
      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.

      Comment

      Working...