SELECT InStr(1,[field1],";") AS p1, InStr([P1]+1,[field1],";") AS p2, InStr([P2]+1,[field1],";") AS p3, Left([field1],[p1]-1) AS F1, Mid([field1],[p1]+1,[p2]-[p1]-1) AS F2, Mid([field1],[p2]+1,[p3]-[p2]-1) AS F3, Mid([field1],[p3]+1) AS F4
FROM 表4;
sql:
SELECT a.*, mid(',' & A.B & ',',b.id1+1,instr(b.id1+1,',' & A.B & ',',',')-b.id1-1) AS aa1
FROM rr11 AS A LEFT JOIN LSB1 AS B ON B.ID1<=LEN(',' & a.B & ',')
WHERE MID(',' & A.B & ',',B.ID1,1)=',' and instr(b.id1+1,',' & A.B & ',',',')>0;