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

At 12:00 PM 12/21/2006, you wrote:
>Date: Wed, 20 Dec 2006 16:52:14 -0800 (PST)
>From: artful at rogers.com
>Subject: Re: [dba-SQLServer] Find the second occurrence of a character
>         in      astring
>To: dba-sqlserver at databaseadvisors.com
>Message-ID: <20061221005214.16706.qmail at web88205.mail.re2.yahoo.com>
>Content-Type: text/plain; charset=ascii
>
>You sidestepped the important issue, JC (well important in some 
>contexts), which is how does one sort this?
>
>A.
>
>----- Original Message ----
>From: JWColby <jwcolby at colbyconsulting.com>
>To: dba-sqlserver at databaseadvisors.com
>Sent: Wednesday, December 20, 2006 4:05:08 AM
>Subject: Re: [dba-SQLServer] Find the second occurrence of a 
>character in astring
>
>For Spanish names even that does not work, although I think the difference
>is not worth fighting for (but I'm not Spanish).  Vega is not the last name.
>De La Vega is the last name.  De la means "of the" as in Of The Vega.  Mi
>amigo in Mexico es Juan De Uriarte, Juan being the first name, De Uriarte
>being the Paternal family name.
>
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com