Remember if you are on SQL Server 2016 or better there is already a function from MS to do this named STRING_SPLIT()