Russell,
If you know all the "block" values you could do this:
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")
CREATE CURSOR myBlocks (block c(5))
INSERT INTO myBlocks VALUES("10")
INSERT INTO myBlocks VALUES("11")
INSERT INTO myBlocks VALUES("12")
INSERT INTO myBlocks VALUES("13")
SELECT mytable.drwno, myblocks.block ;
FROM mytable, myblocks ;
WHERE ","+mytable.block+"," LIKE "%,"+TRIM(myblocks.block)+",%"
