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

Some genealogy software gives you options when sorting names,
basically it's up to you.

Common options include:
"Don't sort on prefix words with less than X letters" (usually 4)
and/or  "ignore lower case words"


On 21 Dec 2006 at 12:00, 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.  :-)
> 
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 

-- 
Stuart