Equinox Online Help - Language Reference - A to Z
SortOrder |
|
|---|---|
| Applies to |       |
| Syntax | Sortorder(StringExpression) |
| Action | [Function] Orders the contents of a string. |
| Scope | Usable anywhere. |
| Notes | This function returns an unprintable string, comprising the letters in StringExpression. The letters are sorted into "dictionary" order, ie. "AaBbCc" and so on. Other characters, such as é, are sorted into the appropriate place. eg "EeéF" and so on. You cannot manipulate the result as a normal string. It may only be compared with another string that has been converted using this function, or the Strcase function. |
| Category | String handling |
| See Also | ChrList, Chrs, Compare, Fill, IsNumber, Left_Function, Len, Match, Maxlen, Mid_Function, Remove, Replace, Right_Function], Search_SearchNext, SetLen, SetMaxLen, SortOrder, SubstituteData |
| Example | The following query expression passes all surnames beginning with the letters A to K. Sortorder(Surname) < Sortorder ("L") |