I have a table that contains the following two fields (along with others):

drwno C(15)     block M
1                 10,11
2                 10
3                 11
4                 11,12,13

Is there a way using sql to return the following cursor:

drwno C(15)     block C(5)
1                 10
1                 11
2                 10
3                 11
4                 11
4                 12
4                 13

If sql is not the best approach, any other suggestions would be greatly appreciated.

Thanks in advance,
Russell