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

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.  :-)