The STRING_SPLIT  is now available in SQL Server 2016 and onwards that splits a string using a separator.  For versions of SQL Server before 2016 it can either be done by using a UDF or using PARSENAME .  PARSENAME  is a SQL Server function used for working with linked servers and replication and parsing a name at a certain level, i.e. Servername.Databasename.Ownername.Objectname.  It will work up to 4 parts/levels in the string to parse.

On the other hand, a UDF such as the one below will accomplish the same task.