默认情况下,SQL Server 里面是不区分大小写的: CREATE TABLE test (id VARCHAR(20)) INSERT INTO test(id) VALUES ('aa') INSERT INTO test (id) VALUES ('ba') INSERT INTO test (id) VALUES ('Aa') INSERT INTO test (id) VALUES ('AA') 查询1: SELECT * FROM test WHERE id LIKE 'a%' 结果: id --------- aa Aa AA 查询2: SELECT * FROM test WHERE id LIKE 'a%' COLLATE Chinese_PRC_CS_AS 结果: id --------- aa