Unanswered: SQL: Numeric Conversion in DB2 Queries
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.