Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A question about a SELECT – SQL statement
Message
From
25/10/2000 12:26:32
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
25/10/2000 10:19:57
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00434023
Message ID:
00434136
Views:
20
Robert,

I've had good luck with SELECT SUM(Amount + $0) AS MyAmount.


>This is my code:
>Select ,sum(AMOUNT) as myamount ……
>My question is: I want myamount to be DATA TYPED as CURRENCY 8.4… any ideas?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform