General information
Category:
Coding, syntax & commands
This may help:
lc="12,345.67"
?val(chrtran(lc,",",""))
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only