[dba-SQLServer] Name parsing

Unfortunately I really don't have a lot of choice.  This is for a 
mailing list and I need to parse them in order to do address validation.

Dan Waters wrote:
> John
> 
> I have a vague memory of an 'official' list of name and all the abbreviation
> permutations - but don't know where to get it.
> 
> I always use just one field for people's names - that way it doesn't matter
> how my users want to enter their names.
> 
> Some cultures put the family name first and the individual's name last (but
> without any commas).  As the world gets 'smaller', we'll have both types of
> names in our databases, and you won't want multiple fields for one person's
> name.
> 
> Dan
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Wednesday, April 16, 2008 3:21 PM
> To: Dba-Sqlserver
> Subject: [dba-SQLServer] Name parsing
> 
> Does anyone have a reasonable efficient name parsing query or udf?  I 
> have names in the format LASTNAME FIRSTNAME MI all in one field.  I have 
> been around enough to know that you run into issues like Mac Donalds - 
> spaces between two words that make up a last name.  I do have the 
> ability to parse the names using my address validation software but just 
> thought I'd throw it out here first.
> 
> Thanks,
> 

-- 
John W. Colby
www.ColbyConsulting.com