>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

Russel,
For a solution that's not SQL select:

Create Cursor myCursor (drwno c(15),Block c(5))
Local Array aBlocks[1]
Local ix
Select myExisting
Scan
  For ix=1 To Alines(aBlocks,Block,.T.,',')
    Insert Into myCursor (drwno,Block) Values ;
      (myExisting.drwno,aBlocks[m.ix])
  Endfor
Endscan
Select myCursor

Cetin