Like we have Split() function in C# that splits the string containing the delimiter, we don't have any predefined function in SQL. Here is how you can create your own function in SQL that splits the string across the delimiter.
Read this post on techiners.blogspot.com