Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How To Split A Comma Delimited String MS SQL 2005

Author  Topic 

venkatmatcha
Starting Member

1 Post

Posted - 2009-09-18 : 10:37:55
Hi All,

I am new to the MS SQL Server development, i need some help to write stored procedure.
Here is the my Req.
i have one large string with comma separated value.
for example: Test1,Test2,Test3,Test4,Test5,Test6
In Stored Procedure, i want to split given string and add splited values into the table, can any one tell me how to do this.

Thank in advance.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-18 : 10:47:40
Search for Split function here

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -