Information générale
Catégorie:
Codage, syntaxe et commandes
Forget that last message of mine. I didn't read closely enough.
Alan
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement