Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALLTRIM in indexes
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00138923
Message ID:
00139579
Views:
28
>Alltrim(Last)+space(1)+Alltrim(First)

This is not sufficient if there are spaces in the first and/or last names. For example, you would want Jim Van to appear before Jim Van Deusen. Yet the index expression above would yield

VAN DEUSEN JIM
VAN JIM

The point of not using AllTrim() in index expressions is to make sure the first and last names are evaluated separately with regard to sort order: i.e., to sort by last name, then by first name if there's a tie.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform