Split string as Array in SQL

Hi,



i was in need to split string in T-sql but i can't find built-in function to do that, thereby i wrote a function to do the following:



By the use of T-SQL:



if you have string like "Ahmed,Eid,Salim" or Ids like "120,234,123,546"

and you need deal with that string as array on SQL DB Engine and find items of it.





The SQL Function like: