Change Numerical Strung to A Number

[szaunbr]

I am working with CR 9 and an Informix DB. It is my payroll database, and I am working on a report using the previous year's salary amounts. This information is store only in an audit table, and is stored as a string, even though the salary is numerical, it is storing it as numerical text.

I need to do some calculations, but I don't know how to turn this string into a number. Is it possible??

Thanks in advance.

 

[satinsilhouette]

tonumber({fieldname})

Thanks so much!
satinsilhouette