Posted by: marulez December 1, 2010
Login in to Rate this Post:
0
?
As long as you have delimeter you should be good to go.
My recommendation is to create a function or stored procedure which splits the string depending upon the delimeter and return the result in table.
Here is a solution which might help you: http://www.codeproject.com/KB/database/SQL_UDF_to_Parse_a_String.aspx
Also in stackoverflow: http://stackoverflow.com/questions/2647/split-string-in-sql
My recommendation is to create a function or stored procedure which splits the string depending upon the delimeter and return the result in table.
Here is a solution which might help you: http://www.codeproject.com/KB/database/SQL_UDF_to_Parse_a_String.aspx
Also in stackoverflow: http://stackoverflow.com/questions/2647/split-string-in-sql