some sql help

UDA

some sql help

I am trying to help coworker. he has a table that stores multiple results (ie: data look like: ans1, ans2, ans3) and he needs to separate them out to use them in some code. i can not find a easy way to get the data out for him. (yes he can do this on the code side but he wants the sql query to do it for him)