SQL split string and modify data in the database table

SELECT * FROM dbo. aabbUPDATE dbo. aabb SET bb = dbo. fun_GetName (aaa, 1), cc = dbo. fun_GetName (aaa, 2), dd = dbo. fun_GetName (aaa, 3) -- string to be split by the first parameter -- number of splits by the second parameter, such as 'aa, bb, the bb in the cc 'string is the 2nd create function fun_GetName (@ Name VARCHAR (200), @ pos int) returns varchar (50) to be split) -- returns a string as begin declare @ I int DECLARE @ ret VARCHAR (50) SET @ I = 0 WHILE (CHARINDEX (',', @ Name, 1)> 0) begin set @ I = @ I + 1 IF (@ I = @ pos) SET @ ret = LEFT (@ name, CHARINDEX (',', @ Name, 1)-1) SET @ name = RIGHT (@ name, LEN (@ name)-CHARINDEX (',', @ Name, 1) end return @ retend

 

No data before modification

Modified Data Format