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:
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:
Posted in Labels: SQL Server | Edit |
0 comments:
Post a Comment