SQL split comma separated row

SQL split comma separated row

pI have a column with a variable number of comma seperated values:/p
precodesomethingA,somethingB,somethingC somethingElseA, somethingElseB
/code/pre pAnd I want the result to take each value, and create a row:/p
precodesomethingA somethingB somethingC somethingElseA somethingElseB
/code/pre pHow can I do this? /p p(I've tried googling implode and lateral
view, but those don't seem to turn up related questions. All the related
SO questions are trying to do much more complicated things)/p