如题所述
我以前有做过用MSSQL查询的,这是代码,你可以测试一下,我手头上没有ACCESS select isnull(b.py,upper(left(a.username,1))) as py ,a.username from ( select 'a3' as username union select UserName from UserTable --修改这里的姓名列~ ) a left outer join ( select 'A' as PY,N'驁' as word, N'啊' as sword union select 'B',N'簿',N'驁' union select 'C',N'錯',N'簿' union select 'D',N'鵽',N'錯' union select 'E',N'樲',N'鵽' union select 'F',N'鰒',N'樲' union select 'G',N'腂',N'鰒' union select 'H',N'夻',N'腂' union select 'J',N'攈',N'夻' union select 'K',N'穒',N'攈' union select 'L',N'鱳',N'穒' union select 'M',N'旀',N'鱳' union select 'N',N'桛',N'旀' union select 'O',N'漚',N'桛' union select 'P',N'曝',N'漚' union select 'Q',N'囕',N'曝' union select 'R',N'鶸',N'囕' union select 'S',N'蜶',N'鶸' union select 'T',N'籜',N'蜶' union select 'W',N'鶩',N'籜' union select 'X',N'鑂',N'鶩' union select 'Y',N'韻',N'鑂' union select 'Z',N'咗',N'韻' ) b on left(username,1) between b.sword and b.word where UserName<>'a3' and py='A' --这里的and py='A'是查询以A拼音开头的姓名,你可以 改成其他的,或者直接去掉就是查询所有的~ order by py
希望采纳
希望采纳
温馨提示:答案为网友推荐,仅供参考