How do i unconcatenate a string in SQL?

I have a string such as:

322,992,124,643,233

being passed from an ASP form to a ms sql stored procedure.  i want too pull out each number and insert them into the same column, but different rows

322
992
124
643
233

How can i do this?  THanks
bdietzAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
pootle_flumpConnect With a Mentor Commented:
Hi

There are more functions and methods than you could ever need here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

I think I use a version of the first one (the table returning function) as I recall. Very easy to use.

HTH
0
 
pootle_flumpCommented:
To be more complete - you could use the first function like this:

INSERT INTO MyTable (MyField)
SELECT      Data
FROM dbo.Split('322,992,124,643,233', ',')

HTH
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hi bdietz,

another option is to use dynamic sql

EXEC('Insert into urTable (UrColumn)  SELECT  '+@AboveString +'')
 

Aneesh R!
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I would also use the function suggested by pootle_flump, as it protects against sql injection, and is more readable also.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.