>>Yes, there are CHARINDEX and SUBSTRING functions in SQL Server. In SQL Server 2016 (I think) they also finally introduced the split function.
>
>Thank you.

You're welcome. Play with the select statements first until you get it parsed correctly.

This blog post may help

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/parsing-fullname-field-to-individual/