formatting - Query number of decimal places in a sql server resultset -

I have a table in which one type of field is numeric (2810) . I would like to display the archives with a monospace font, and I would like to display decimal places in a decimal number so that they stand the timeline of the correct alliance.

Is there a way to find the maximum number of decimal numbers that can be found in a given result set so that I can format each record accordingly accordingly?

Edit: Sorry, I should be clear ... If there are numbers with only 3 decimal places in the result set, then all numbers can have only 3 decimal places (zero With pad).

Monospaced fonts are completely a presentation issue ...

< P> I do not need you to do the right alignment when I do the test:

  Make Table [DBO]. [Tab]] ([number] [numerical] is not (28, 10)) [for example] [dbo]. [Table] values ​​(1.1234567890); INSERT [examples]. [DBO]. [Tab]] value (1.123456789); INSERT [examples]. [DBO]. [Table_1] Price (1.1234567); [Example]] [number] from [number] [DBO]. [Table_1]  

... Returns:

  num ------- -------- 1.1234567890 1.1234567890 1.1234567000  

So the question is - what are you trying to do, which is not producing you as you wish?