how to split and show in new row in sql

Oct 8 2013 1:42 AM

How to Split aafter comma and display in new Row
i have empid as 1,2,5,3,4
and i want to split and display as
1
2
5
3
4
with emnpname
1=a
2=b
3=c
.........................
please help