SQL Queries||How to split the name column into First and Last Name?

SELECT *,SUBSTRING(name,1,CHARINDEX(',',name)-1) AS First_Name
,SUBSTRING(name,CHARINDEX(',',name)+1,Len(name)) AS Last_Name
FROM Test