> I have a table with metric, imperial, fraction columns. Have "metric_equivalent_magnitude" and "metric_equivalent_unit" columns and do all your sorting &c. via those columns. Use the relatively new generated (or computed/calculated) columns to calculate these. That way, you get the conversion correct once and you don't have to worry about it any more! That way, you can compare between cubits, furlongs and kilometres or barrels, hogsheads and litres & American and British imperial units. You might also want a metric_equivalent_type to ensure that you're not comparing lengths with volumes, masses or velocities... &c...? Pól...
