Try
ROUND(EVAL( CHRTRAN(lcVal, ".,", ""))/100,2)
EVAL( CHRTRAN(CHRTRAN(lcVal, SET("SEPARATOR"), ""), SET("POINT"), ".") )
>Hi all,
>
>Does anyone know of a quick and easy (to be used in a select statement) way to convert a transformed amount back to its value.
>
>If I originally had the number 12345.67
>this has become the string "12,345.67" or "12.345,67" depending on the separators.
>
>and now I need to do a numeric > or < so I need it as a number again.
>
>Any ideas?
>PS I can't store it as both so that is not an option.
--sb--