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)

is run

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.