Did a bot post this thing? :crazy:
I would not normally see myself using any SQL code to do something like this. What SQL can do and what SQL should do are not the same thing.
But if I had to use SQL for this, I'm thinking I would put these unit conversion factors in a table and look up the value I need, rather than building the Kraken of all case statements.