现在有个表TEL
id num
1 13898474747
2 13898474748
3 13898474749
4 13898474750
5 13898474751
我想显示出
138****4747
138****4748
138****4749
138****4750
138****4751
就是每个数据的前3位，后4位
------解决方案--------------------
select left(ltrim(num),3)+ '**** '+right(rtrim(num),4) from Tel
------解决方案--------------------
Select Stuff(num, 4, 4, '**** ') As num From TEL