Hi Michael;

   My guess is that your app & db would need to be refactored in order to handle that aspect properly. 

Regards... Chris

Rename the table and create a view with the old name of the table. The view would look at a config table to see which type of units is desired. If it is US or Imperial, the view would do the conversion, perhaps by calling a user defined db function.

For updating, there would have to be an update trigger that would convert the incoming value to metric, based on the unit type from the config table.

This would require no changes to the PowerBuilder code.

Guys,

Thank you for your responses.

The view / trigger solution is the solution we're looking at. Although it means little change to the application there's still a lot of work to be done in the DB. I was just hoping that there was some sort of "magic bullet", but apparently not.

I guess this is what I get paid for!

Thanks once again.

Regards,

Michael Connell.