Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sort order and case
Message
From
09/04/2001 01:36:51
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Sort order and case
Miscellaneous
Thread ID:
00493439
Message ID:
00493439
Views:
55
How do I get a key to sort in alpha order without regarding case. For instance take the following.

Default sort order
Adams
Jones
Smith
deVant

What I want is

Adams
deVant
Jones
Smith.

Because of the lower case on deVant it goes to the end after all upper case items.

I looked at the set commands and didn't see anything that looked it would work.

Thanks

Dennis
Next
Reply
Map
View

Click here to load this message in the networking platform