Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select with math
Message
From
14/12/1999 08:02:23
Gary Robinson
Thomcomp, Inc.
Conshohocken, Pennsylvania, United States
 
 
To
14/12/1999 07:44:34
Paige Chandler
P. Chandler Enterprises
Germantown, Maryland, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: SQL Select with math
Miscellaneous
Thread ID:
00303271
Message ID:
00303284
Views:
13
Your original command should be SELECT rate/2 as newrate from....., however I don't see how this relates to the problem in the 1st paragraph.

You could kill 2 birds with one stone by saying:

SELECT STR(rate/2,10,2)+"%" as newrate from...


Gary Robinson
Thomcomp, Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform