@JeffModen
I think it is clear which option I must go with here. It was a nice ride with Delimited
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,' ')
graz
May 5, 2020, 2:45am
#2
I don't know how you even see the spaces in your source data
2 Likes
Utf8 glasses, must have fashion wear for all sql devs
2 Likes
Still, with STRING_SPLIT we don't know the order in which the tokens appear in the string, right?
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