You can define how text fields are sorted.
Text fields are not generally used for searching
Often, sites want to set preferences for sorting with:
•Apostrophes.
•Mc or Mac.
•A, An or The.
•hyphens.
•Roman Numerals.
You can for example, replaces apostrophes or the initial A, An, or The with nothing. Names such as O'Rourke would be sorted as OROURKE, and the title "A Black Cat" will be sorted as BLACKCAT.
Replacements are not case sensitive.
To change Text Sorting
1.Go to Tools menu > System Maintenance > Text Sorting.
2.Click on the File drop-down menu and select the name of the datafile.
3.Click on the Field drop-down menu and select name of the field. If the field has text sorting, details will appear on screen.
4.Click in the Replace Mode field and choose the type of replacement.
5.Click in the Search String field and enter the string of characters the system should search for, followed by ].
6.Click in the Replace String field and enter the word or set of characters the system should use instead. If you want to ignore that term when sorting, leave this field blank.
7.Save the record.
The Text Sorting Configuration window showing configurations for sorting Mc and Mac into Mac.