create database testdb
go
use testdb
go
create table Product (goodID int identity primary key, goodName varchar(20))
insert into Product values('abc')
insert into Product values('aBc')
insert into Product values('abc')
select * from tb where goodName like '%b%'
select * from tb where goodName like '%B%'
select * from tb where goodName COLLATE SQL_Latin1_General_CP1_CS_AS like '%B%'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/195394/viewspace-611294/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
