Sort question - Fractions, Metric etc

[Bret Stern <bret_stern@xxxxxxxxxxxxxxxxxxxxx>]

I have a table with metric, imperial, fraction columns.

Is there a way to sort correctly using imperial (eg; .125, .375, .437 -> 
1., 1.125)

Couldn't handle it with ORDER BY ASC, DESC args so I added a sort_column 
and sorted based

on those values eg; 1,2,3,4,5,6 indicating the value I need to show in 
which sequence.


Just curious what the pro's do

Bret