access 拆分字符串
电话格式
86-区号-电话
拆分出区号和电话怎么写

[解决办法]
select left(replace(电话,"86-",""),instr(replace(电话,"86-",""),"-") as 区号,mid(replace(电话,"86-",""),instr(replace(电话,"86-",""),"-") as 电话 from 表