select top 200
CASE
WHEN LEN(UserName)>2 THEN SUBSTRING(UserName, 0, 2)+ '*'+SUBSTRING(UserName, 2, 1)
WHEN LEN(UserName)=2 THEN SUBSTRING(UserName, 0, 2)+ '*' end AS Surname,
SUBSTRING(Phone, 0, 4)+ '***'+ SUBSTRING(Phone, 8, 4) AS PhoneNumberMasked from xxx where isnull(phone,'0')<>'0'order by isnull(score_u,0) desc,isnull(usetime,2147483646) asc
07-22
761
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)