SELECT W.ZID, W.ZTEXT_LIST
FROM (SELECT tblDTO.[zID], MID(tblDTO.[ztext],1,30) AS ZTEXT_LIST,ZTEXT & "_1" AS ZTEXT_SORT
FROM tblDTO
UNION ALL SELECT tblDTO.[zID], "~~~" &MID(tblDTO.[ztext],31,30),ZTEXT & "_2"
FROM tblDTO WHERE LEN(ZTEXT)>20
UNION ALL SELECT tblDTO.[zID], "~~~" &MID(tblDTO.[ztext],61,30),ZTEXT & "_3"
FROM tblDTO WHERE LEN(ZTEXT)>20
ORDER BY 3) AS W;