[dba-SQLServer] Name parsing

jwcolby jwcolby at colbyconsulting.com
Wed Apr 16 15:20:58 CDT 2008


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



More information about the dba-SQLServer mailing list