STRING_SPLIT vs DelimitedSplitN4K

Transact-SQL
1

@JeffModen

I think it is clear which option I must go with here. It was a nice ride with Delimited

image

		if OBJECT_ID('tempdb..#words') IS NOT NULL
			drop table #words

		create table #words(word nvarchar(4000))

		insert into #words
		select N'ከለታት አንድ ቀን በአንዲት ከተማ'

		select * 
	     from #words
		 cross apply sqlteam.dbo.DelimitedSplitN4K(word,' ')

		select * 
	     from #words
		 cross apply STRING_SPLIT(word,' ')
2

I don't know how you even see the spaces in your source data :slight_smile:

2 Likes
3

Utf8 glasses, must have fashion wear for all sql devs

:nerd_face:

2 Likes
4

Still, with STRING_SPLIT we don't know the order in which the tokens appear in the string, right?

5

That is correct James (though order is not an issue for me). But the glaring issue is it is breaking down words on each character. I think this has to also do with collation , digging into this further