concatenation problem

[cogjai]

Hi,

I need to concatenate decimal value with an string and i am using db2 as a database is there anyway to concatenate decimal with string actually i am able to concatenate but i am not getting the expected one for ex decimal value is like
000000.001 and another decimal value is like 000000.050 i am getting an output 000000.001 000000.050 using cast_char function.But My output must be something like this 1 50.

Is there any way to achieve this kindly help me in this issue.

Thanks & Regards,

Mani.

Thanks in Advance

 

[DoubleD]

How about this:

(Value1 * 1000) || " " || (Value2 * 1000)

I am what I am based on the decisions I have made.

DoubleD