I am trying to retrieve a string of data from a single column and then explode it out and use its values to create a check box list
user enters their id.
SELECT [IMR], [Social] FROM [AlphaRoster] WHERE ([Social] = @Social)
pulling out the record in column IMR
however im left with a string. value1,value2,value3....
i would like to know how i could seperate those values in asp.net
i know in php i would use the explode() but how do i get the check box to list those values not just one row containing a string.
Thank you for your help.