sqlserver判断字符串是否含有大写字母
select * from (
select user_uid,lower(USER_UID) as lowuseruid,USER_NAME from [dbo].[tablename] ) a
where user_uid COLLATE Chinese_PRC_CS_AS not like ‘%’+lowuseruid+’%’
关键词
COLLATE Chinese_PRC_CS_AS
select * from (
select user_uid,lower(USER_UID) as lowuseruid,USER_NAME from [dbo].[tablename] ) a
where user_uid COLLATE Chinese_PRC_CS_AS not like ‘%’+lowuseruid+’%’
关键词
COLLATE Chinese_PRC_CS_AS