[dba-SQLServer] Parse name field

John W. Colby wrote:

>Does anyone have a SP (or whatever) that can parse a single field with first
>/ middle / last name into separate fields?
>
>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
>
>
>  
>
This wouldn't take long to write, but first let's get the requirements 
straight....

Assume the delimiter is a space?
Assume that if there is only one space, then there is no middle name?
Assume that if there are more than two spaces, the person has two middle 
names?

Yay or nay?

A.