SELECT top 10 LEFT(姓名, 1)+'**' AS name, LEFT(姓名, 1)+'*'+RIGHT(姓名, LEN(姓名)-2) AS showname ,姓名 FROM 表名