[dba-SQLServer] Name parsing

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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com