sele * from 表1 into curs tmp use in 表1 sele ctod(left(rq,4)+"."+subs(rq,5,2)+"."+subs(rq,7,2)) rq,字段1,字段2,字段3 from tmp orde by 1 into tabl 表1