Issue On Values when separate it to value and text?

[harishgg1]

Looks like you have very little experience in SQL !!! ..

see my solution ... where i am using string_split put DelimitedSplit8K

Njoy