Database Field of Type: Name Sorts Incorrectly

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.
Example: If you create a field called 'Full Name' of type Name and enter the following data into the field:
William Gold
Alex Gold
Gordan Gold

When you sort, you expect the results to be:
Alex Gold
Gordan Gold
William Gold

But the results are:
Alex Gold
William Gold
Gordon Gold

If you change the name Gordon to Cassey, it will sort correctly. If you change the name Gordon to Harry or Gary, the sort will be incorrect.

The ClarisWorks development team is currently looking into this issue. The only work around is to change the 'Full Name' field into 2 text fields 'First Name' and 'Last Name' and sort by 'Last Name' then 'First Name'.
Published Date: Feb 18, 2012