Converting string to numeric using query builder

[#1]

Hi

Is there any way to do this? I tried a computed column OLD_VAR * 1 but got the error attached, I want to do this on point click because is faster than creating a program just to convert one var.

[ChrisHemedinger · Accepted solution]

You can do it by defining an Advanced Expression as a calculated column with the INPUT function, using something like:

  input(t1.CNPJ_CPF,best12.)

(replace "best12" with appropriate informat spec to get the precision you need).

[#3]

Thanks Chris !! 😉