Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to do a weird ordering of data
Message
 
To
13/05/2011 11:22:33
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01510568
Message ID:
01510610
Views:
60
Actually, the field is named RELATECD and the values are E1, S1, C1, C2, C3, and so on. I can give that a shot and see how it comes out.
Thanks!
Cecil

>Assuming "Insured" and "Spouse" are logical fields, and there is a field for BirthDate (D):

>SELECT ... ORDER BY insured DESC, spouse DESC, BirthDate
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform