先设置大小写敏感
ALTER TABLE tablename
ALTER COLUMN colname nvarchar(100) COLLATE Chinese_PRC_CS_AS 查询:没测试过
select * from tablename where [name] like '%kelr%'
ALTER TABLE tablename
ALTER COLUMN colname nvarchar(100) COLLATE Chinese_PRC_CS_AS 查询:没测试过
select * from tablename where [name] like '%kelr%'
select * from tablename where Upper([name]) like '%KELR%'函数记不清楚了,看帮助
select * from tablename where lower([name]) like '%kelr%'
select * from tablename where upper([name]) like '%kelr%'
其中upper是將大寫轉小寫。
lower是將小寫轉大寫