Sorting compound names

[jda]

>
>What wonder me.
>
>That user have blame you that you do not like German.

I'm just an imperialist American! :->

>
>Does exists German apps which can do this task?
>
>May be some of them open sources?
>
>Then you can study how
>
>


What these folks want is the ability to alter record sorting so that 
it ignores prefixes in surnames. This is apparently standard in 
German, Swedish, Dutch, and no doubt other languages.

I don't know of open source dbs that do this, but as I said, EndNote 
(a competitor of mine) lets you create a list of words that are to be 
ignored when sorting names (e.g. von, van, de, etc.). Papyrus (a now 
defunct ex-competitor) allows "German sorting rules", which did much 
the same. This approach, to provide this sort of sort as an option, 
should satisfy most folks who want this feature I think.

I'll be trying the tmp table approach to see if I can do just this. 
Given how fast Valentina is, I think performance will probably just 
fine (most sorts will be on less than 200 records).

Jon