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