Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
There HAS to be a better way
Message
 
To
01/02/2013 12:24:33
Rich Pupko
Retired
Henderson, Nevada, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: There HAS to be a better way
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01564910
Message ID:
01565199
Views:
80
How about:
SELECT Uniq_Key, MAX(STR(isProd) + STR(Version)) FROM MyCursor;
GROUP BY Uniq_Key INTO CURSOR tmp3

If Version goes over 9, you can add PADL().

Jerry
Previous
Reply
Map
View

Click here to load this message in the networking platform