How to split comma separated string values into columns ?

SELECT id, Name, '' as Nam1 ,'' as Nam2,'' as Nam3 from tblRegister
Select id,
Name,
ISNULL([Nam1],'') AS [Nam1],
ISNULL([Nam2],'') AS [Nam2],
ISNULL([Nam3],'') AS [Nam3]
From (
Select id,
Name,
'Nam'+CAST(ROW_NUMBER()OVER(PARTITION BY id order by id) as int) as Col,
Split.value
From tblRegister AS REG
Cross apply string_split(Name,',') AS Split)
AS Tbl
pivot (MAX(value) For Col IN ([Nam1],[Nam2],[Nam3])
) AS Pvt
 
(1 row affected)
Msg 208, Level 16, State 1, Line 5
Invalid object name 'string_split'.
Completion time: 2022-03-04T23:34:31.3593222+05:00

Rijwan Ansari Yes Like this how can i do