Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting a Numeric/Decimal field into a Character Fiel
Message
De
07/01/2004 08:31:10
 
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00864575
Message ID:
00864589
Vues:
9
Hi Franco! You beat me by two seconds!!

>Hi Julie,
>try with
>
>ALLTRIM(STR(field,10,2))
>
>take a look (in the help) at the STR() function which accept more than 1 parameter
>
>HTH
>franco
>
>>I have a (hope to be) simple one for you.
>>
>>I am trying to convert a numeric field with two decimal places into a character field. That is easy enough, but I want to carry over the decimal and the two characters behind it. If I use ALLTRIM(STR(field)) and the record is 200.50 I get 201 in my converted field. I want to see 200.50 not 201.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform