[dba-SQLServer] Find the second occurrence of a character in a string

I would look up the difference between Phone Book and Dictionary collations

artful at rogers.com wrote:

>I appreciate your point, but I'm still not certain of the best way to go with my question, which concerns the way to handle some unusual surnames. 
>
>van den Berq
>la Flame
>de la Vega
>Ben Gurion
>
>and any number of names that begin with "al". Or "da" as in Leonardo. My very limited Italian suggests that Leonardo was born in a town called Vinci.
>
>So how does one sort such a list? On the capitalized word? On the first letter of the two or three words considered the surname?
>
>Advice from Europeans, Asians, Africans, or even North Americans familiar with this problem, would be appreciated. I have no immediate problem that requires this solution. This is purely theoretical at the moment, but who knows, someday I may need the answer.
>
>TIA,
>Arthur
>
>----- Original Message ----
>From: Robert L. Stewart <rl_stewart at highstream.net>
>To: dba-sqlserver at databaseadvisors.com
>Sent: Thursday, December 21, 2006 1:41:04 PM
>Subject: Re: [dba-SQLServer] Find the second occurrence of a character in a string
>
>You put it in the right columns to begin with and don't try to
>parse it out of a single one.  :-)
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada