Splitting comma delimited results into rows

[programmher]

Here is my code:

SELECT CData.value('(/fields/Genres)[1]', 'varchar(255)')FROM Categories WHERE ReqNum = 9281

Here are my results:

King, Saul, Robb

I need the results to display like this:

King
Saul
Robb

How do I modify my script so my results display in rows instead of the comma delimited fields?

[ck9663]

Here find one here...

Good Luck!!!

~~ CK