Split a string with mssql11.06.20

example:

DECLARE @strInput VARCHAR(100);
SET @strInput = 'Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday'
 
Select VALUE FROM STRING_SPLIT(@strInput, ',')
GO

fully example to split and save a wordlist:

DECLARE @tmp table(descr varchar(400))
DECLARE @tmp2 table(word varchar(400))

INSERT INTO @tmp
SELECT DISTINCT  av0_description AS [description]
FROM [SL].[dbo].[av0_style]
WHERE av0_not_to_sale = '0'
AND av0_metal NOT IN('PK')
AND av0_not_active = '0'
AND av0_finding = '0'
AND F34_av0_a = '0'
AND av0_exlusive_item = '0'
AND av0_group NOT IN('CA','M','MT','PT','RU','SRV','PIC','STK')
AND av0_Group2 NOT IN('CA','M','MT','PT','RU','SRV','PIC','STK')
UNION
SELECT DISTINCT av21_Description AS [description]
FROM [SL].[dbo].[av21_kode_for_style]

UPDATE @tmp SET descr = replace(descr, '.', '')

DECLARE @text varchar(max)
SET @text = (SELECT descr + ' ' AS 'data()' FROM @tmp FOR XML PATH(''));

INSERT INTO @tmp2 
SELECT DISTINCT value FROM string_split(@text,' ')

INSERT INTO sl_h.dbo.words(word)

SELECT word
FROM @tmp2

LEFT JOIN sl.dbo.av0_style as s
ON word = s.av0_style

LEFT JOIN sl.dbo.av0_style as c
ON word = c.av0_code

WHERE ltrim(rtrim(word)) <> ''
AND s.av0_style IS NULL 
AND c.av0_code IS NULL

AND word LIKE '[a-zA-Z]%'
AND word LIKE '%[a-zA-Z]'

AND LEN(word) > 3
--AND NOT EXISTS (SELECT top 1 av0_code FROM sl.dbo.av0_style WHERE av0_code = word)
--AND NOT EXISTS (SELECT top 1 av0_style FROM sl.dbo.av0_style WHERE av0_style = word)
AND NOT EXISTS (SELECT top 1 word FROM sl_h.dbo.words)
group by word

https://codingsight.com/several-ways-to-insert-split-delimited-strings-in-a-column/

Anonymous

Split a string with mssql11.06.20

Information Epoch 1594663696