Scott Abraham
asked on
SQL Help Convert Cast Query
I have a table with the following data
ID Max Value
1 1.56
2 10.753
3 100.008
4 18.6
5 .4
6 2.47
7 1.49
8 13.65
9 29.68
10 37.22
I want to select all records, but have Max Value displayed like 000.000.
For Example
ID Max Value
1 001.560
2 010.753
3 100.008
4 018.600
5 000.400
6 002.470
7 001.490
8 013.650
9 029.680
10 037.220
Any help is appreciated
ID Max Value
1 1.56
2 10.753
3 100.008
4 18.6
5 .4
6 2.47
7 1.49
8 13.65
9 29.68
10 37.22
I want to select all records, but have Max Value displayed like 000.000.
For Example
ID Max Value
1 001.560
2 010.753
3 100.008
4 018.600
5 000.400
6 002.470
7 001.490
8 013.650
9 029.680
10 037.220
Any help is appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This worked
select id,
, format(Max Value, '000.000') as value
from table
select id,
, format(Max Value, '000.000') as value
from table
... Ok, and did what I gave you not work?
ASKER
Your solution works great.
ASKER
Found answer not relating to posted solution.