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

JWColby jwcolby at colbyconsulting.com
Fri Dec 22 08:24:10 CST 2006


LOL.  You apparently don't deal with the real world.  

I get lists of names, the entire name in one field.  Now.... How helpful was
your answer? 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L.
Stewart
Sent: Thursday, December 21, 2006 1:41 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Find the second occurrence of a character in
astring

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


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list