Hi,

I have a DB2 Query in which i have to multiply Two columns.
i.e., Select Column1 * Column2 From Table Name
In this table the Column 1 is numeric but Column 2 is character having the values 1.56.
Now what is the inbuilt reserved word which i can use to convert '1.56' string to 1.56.

In Oracle we have To_number.But i am unable to find any such Reserved Word in DB2. Please Help.

Thanks & Regards,
Ragi

Ragi,
Look at the numeric functions: INTEGER, DECIMAL, FLOAT, DOUBLE. Each one will take your string and return a numberic of the datatype of the function name.

HTH

Andy

Hi Andy,

SELECT 3 * DECIMAL('12.2',3,1) FROM <Table> Works fine.
Thanks A Lot.
Appreciate Your Help!!!

Regards,
Ragi