I am trying to write a SQL Server stored procedure that splits a comma delimitted string into multiple arrays.
Eg.
From:
str = "12, 1, 5"
to:
arr(0) = 12
arr(1)=1
arr(2)=5


Does anyone know if T-SQL has a function similar to vb's "split"?