Hello,
I am trying to sort a view of products by sort1 then sort2. When I look at the sort1 column I notice that the data is sorted without regard to the decimal point which is not showing. For example the sort below is sorting 400 then 50 then 500 as well as 600 the 75 then 800. I would like to sort the order as 50, 75, 400, 500, 600, 800
A4414 4 X 4 X 1/4 ANGLE 6.6 20 400
A4438 4 X 4 X 3/8 ANGLE 9.8 40 400
A4438 4 X 4 X 3/8 ANGLE 9.8 20 400
A121218 1/2 X 1/2 X 1/8 ANGLE 0.38 20 50
A121218 1/2 X 1/2 X 1/8 ANGLE 0.38 20 50
A531238 5 X 3-1/2 X 3/8 ANGLE 10.4 40 500
A531212 5 X 3-1/2 X 1/2 ANGLE 13.6 40 500
A66516 6 X 6 X 5/16 ANGLE 12.5 40 600
A6312516 6 X 3-1/2 X 5/16 ANGLE 9.8 40 600
A343418 3/4 X 3/4 X 1/8 ANGLE 0.59 20 75
A343418 3/4 X 3/4 X 1/8 ANGLE 0.59 20 75
A8612 8 X 6 X 1/2 ANGLE 23 40 800
A8834 8 X 8 X 3/4 ANGLE 38.9 20 800
Thanks
John