CREATE CURSOR mytable (drwno C(15), block M) INSERT INTO mytable VALUES( "1", "10,11") INSERT INTO mytable VALUES( "2", "10") INSERT INTO mytable VALUES( "3", "11") INSERT INTO mytable VALUES( "4", "11,12,13") SELECT drwno, PADR(MLINE(CHRTRAN(block, ",", CHR(13)),1),5) AS oneblock ; FROM mytable ; HAVING NOT EMPTY(oneblock) ; UNION ALL ; SELECT drwno, PADR(MLINE(CHRTRAN(block, ",", CHR(13)),2),5) AS oneblock ; FROM mytable ; HAVING NOT EMPTY(oneblock) ; UNION ALL ; SELECT drwno, PADR(MLINE(CHRTRAN(block, ",", CHR(13)),3),5) AS oneblock ; FROM mytable ; HAVING NOT EMPTY(oneblock)>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 >>
>drwno C(15) block C(5) >1 10 >1 11 >2 10 >3 11 >4 11 >4 12 >4 13 >>