Hi,

I was wondering if anyone can give me a hint with this problem.

The query:

SELECT ID_Number, WeightValue, WeightCode, |||| WeightLB, WeightKG ||||
from tbl_weight

Fields WeightLB and WeightKG don't really exist in the table and would be generated dynamically in the query.

Here is an example of what exactly I need to do:
I read the first record from table tbl_weight.
The values are as follows:
ID_Number: ABC, WeightValue: 70, WeightCode: KG
The WeightValue is 70KG, but I also want to know how many pounds (LBs) this is...
Because of that I automatically select 70 for the WeightKG, but calculate WeightLB dynamically by multiplying 70 by 2.2.
The final result:
ID_Number: ABC, WeightValue: 70, WeightCode: KG, WeightLB: 154, WeightKG: 70
In that case I would have all the info I need...
Similar thing happens when I get LB and need to dynamically calculate KG, except I'll multiply by 0.45.

I assume I would need to use some kind of IF statements in the query. Any ideas?

Thanks.

CASE
WHEN WeightValue = 'KG' THEN ...
ELSE
END as converted_weight

Thanks! It works great!

No problem.

If you download one thing today, make it this:
http://ourworld.compuserve.com/homep...l/HTM_COOK.HTM

It has everything you wanted to ever do with SQL in DB2. Incredibly valueable resource, and unbelievably it's FREE.

Cool, thanks!