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

LOL. Reality does have a way of intruding! But sometimes I invite it, and am declined. Allegedly there is a list of first and last names that can be downloaded from the US Census Bureau, but I can't find it. Can anyone with site-navigation skills better than mine locate said list? I need it for an experiment (benchmarking).

TIA and Merry Christmas,
Arthur

----- Original Message ----
From: JWColby <jwcolby at colbyconsulting.com>
To: dba-sqlserver at databaseadvisors.com
Sent: Friday, December 22, 2006 9:24:10 AM
Subject: Re: [dba-SQLServer] Find the second occurrence of a character in astring

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?