Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting a Numeric/Decimal field into a Character Fiel
Message
From
07/01/2004 08:31:10
 
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00864575
Message ID:
00864589
Views:
10
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform