34,576
社区成员
发帖
与我相关
我的任务
分享
declare @a varchar(100)
declare @i int
set @a= 'abcDEeigHUie'
set @i=1
while @i<=len(@a)
begin
if ascii(substring(@a,@i,1))>=65 and ascii(substring(@a,@i,1))<=90
break
set @i=@i+1
end
print @i
declare @a varchar(100)
set @a= 'dddDEeigHUie'
select patindex('%[ABCDEFGHIJKLMNOPQRSTUVWXYZ]%',@a COLLATE Chinese_PRC_CS_AS)--OK
select patindex('%[A-Z]%',@a COLLATE Chinese_PRC_CS_AS)--error