General information
Category:
Coding, syntax & commands
Remember that Set Decimal will govern how many decimals are returned.
Alan
>>This may help:
>>lc="12,345.67"
>>?val(chrtran(lc,",",""))
>
>It does for that instance but not if the value had been transformed into "12.345,67" in which case it returned 12.3457
>
>
>>
>>>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