How to Right Align Numeric Values in Result Panel in SQL Server?

Generally we apply right alignment to numeric values in our project for easily access and its one of convention to apply right align for numeric. We can also apply this in SQL.

Steps:

1) Open SSMS à Tools à Options..

2) Query Result à SQL Server à Result to Text

3) Check ‘Right align numeric values’ à save it and see result by executing query in new Query Window.

Note: It only works for ‘Result to Text’ option.

Result: