select * from 表名 where cast(left(列名,2) as varbinary(4))=cast('AB' as varbinary(4))
/* select * from AllTableData_BK where TableName collate Chinese_PRC_CS_AS_WS like 'SO%'select * from AllTableData_BK where TableName collate Chinese_PRC_CS_AS_WS like 'So%' */ select * from 表名 where 列名 collate Chinese_PRC_CS_AS_WS like 'AB%' 这就查询出区分大小的数据。。
collate Chinese_PRC_CS_AS_WS 区分大小写
select * from tablename where left(colname,2)='AB'
select * from tbl where ascii(left(name,1))=65 and ascii(substring(name,2,1))=66实在不行用ASCII码来区分
/*
select * from AllTableData_BK
where TableName collate Chinese_PRC_CS_AS_WS like 'SO%'select * from AllTableData_BK
where TableName collate Chinese_PRC_CS_AS_WS like 'So%'
*/
select * from 表名 where 列名 collate Chinese_PRC_CS_AS_WS like 'AB%'
这就查询出区分大小的数据。。
区分大小写