TMG-L Archives

Archiver > TMG > 2004-12 > 1104389837


From: DRobertson <>
Subject: RE: [TMG] v6 - Buggy Surname Sort
Date: Thu, 30 Dec 2004 08:57:17 +0200
References: <200412300406.iBU46OeU008662@mail62.megamailservers.com><000701c4ee2c$0cb92b10$6501a8c0@lgk4600>
In-Reply-To: <000701c4ee2c$0cb92b10$6501a8c0@lgk4600>


Linda,

At 06:57 AM 2004/12/30, you wrote:
>Janis,
>
>Thanks. I'm not doing very well at explaining this. One more try,
>please. Here are the names again (in sorted order on the PE & Picklist)
>with added detail of how each surname is actually entered.
>
> BOTELER, John (Sir) ... Surname = Boteler, SortSurname = Boteler
>snip
>
>The sort order simply makes no sense to me based on the way I've entered
>the names. I think John and Margaret should sort together since their
>SortSurnames are the same. Right?? For the record, I'm not using the
>PreSurname field here.

Given that John seems to be the only individual that has a unique part
(Sir) in his name I wonder if that is somehow causing the anomaly in the
sort function? Have you tried removing it (Sir) from John to see what results?

Hope this helps.
Delia Robertson


This thread: