28,409
社区成员




CREATE TABLE tb)(id int,name VARCHAR(10),firstChar VARCHAR(1))
INSERT tb SELECT 'aaaadfa','a'
UNION ALL SELECT 'bcdfasdf','b'
UNION ALL SELECT '中国人','z'
dim strs
strs="A B C D E F G H I J K L M N O P Q R S T U V W X Y Z"
Set Rs = Conn.Execute("SELECT * FROM tb WHERE CHARINDEX(firstChar,'" & strs & "')>0")
Do While Not Rs.Eof
...