access 拆分字符串电话格式86-区号-电话拆分出区号和电话怎么写[解决办法]select left(replace(电话,"86-",""),instr(replace(电话,"86-",""),"-") as 区号,mid(replace(电话,"86-",""),instr(replace(电话,"86-",""),"-") as 电话 from 表
