right align numbers in table / view

Posted on 2008-10-14
Last Modified: 2010-07-27
ok, newbie question ...

using SS v2005. When I open a table or a view the numerical fields are left aligned? I would have thought they should be right aligned by default ? i.e. like in Access 2003/2007?

how do I right align numbers in a table or view
Question by:LukeB
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Accepted Solution

Maxi84 earned 250 total points
ID: 22718522
I don't believe there's any way to right-align numerical data in Management Studio / Query Analyzer.  Previous versions of MS Dynamics AX (Axapta)  right-aligned fields by padding the data with leading spaces, but this was a BAD idea, and fortunately discontinued when version 4.0 was released.  Text alignment and formatting is something that should be done in the presentation layer ONLY.
LVL 23

Expert Comment

ID: 22718662
I'd echo what Maxi84 said, and I'd have to question why it's an issue? But to offer a workaround, you could just copy/export the results into Excel.

Author Comment

ID: 22718868
thanks Maxi, most of the times the data will be presented in views to a Front End or report.

Adathelad, well I would think that is obvoius, because it is easier for the human eye to look at numbers right justfied :


Access and Excel do by default, so part of the Microsoft crowd agrees with me!
LVL 23

Expert Comment

ID: 22718918
You misunderstood my point (or rather I didn't answer clearly enough!) - I totally agree with numbers justified to the right being easier to read + being the standard alignment and wasn't querying the point of that aspect. It does beg the question, why doesn't MS implement the same in SQL Server as (e.g. Excel, Access) as you point was was more based on the fact that OK, it would be nice/ideal if it did align to the right, but the whole point of SSMS/Query Analyser isn't as an end-user day to day UI that will display things in pretty/customised fashion - i.e. was trying to identify if you're using it for that purpose, when you should be doing this in the presentation layer. If the display/formatting like this in SQL Server was an issue, it comes across as if you're using it for some end-user purpose.

Not sure if I've clarified my response, or muddied the water further still!

Author Comment

ID: 22723061
hi adathelad

no problem..
no, not 'really' using for presentation viewing, sorry I should have been clearer. I say not 'really' for I mysefl being the developer do look at a table more often in the SSMS/QA (to wit, if they supply a viewer why not look at the data?) and it is not easy to look at some data that way, espeicailly the real example I gave.

Less so, I have some advanced users that will be using the SSMS/QA to do ad hoc queries, again, to look at the data rather than thru the front end. But they won't be looking at the data that way day-to-day and will be even more reason for me nattering at them 'don't open tables directly, use a query view in SSMS/QA or the Front End or do a query in the FE.

thanks, i'm a newbie with SQLServer and was surprised at this.

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Throw Error 7 35
Need SSIS project 2 30
How can I retrieve the column names from a T-SQL table? 2 16
How to trim a value in SQL 2 28
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question