Using convert weight files in SQL

[Tomasz Skorża <t.skorza@xxxxxxxxxxx>]

Hi

I have some problem how to use convert files directly in SQL.

Convert file it is file where is setting up that i.e.:
1) 1 KG = 100 DK
2) 1 TN = 1000 KG
3) 1 KG = 1000 G and so on.

In second file there are some special conversion for items i.e.

1) Item1 1EA(each) = 2,5 KG
2) Item2  1EA = 1,5 KG and so on.

Our ERP - JDE World - have an program to convert one unit to other, but 
how to do it in S QL statements?

Until now I using CASE
i.e. when I woul like to get KG I write:

CASE WHEN UnitMeasure = DK THEN Weight/100
ELSE Weight
END

But in is not so clear and smart way.

Have you any ide how to use conversion factor from these two files?