declare @a varchar(100)
set @a='1234BFRS'
select cast(substring(cast(@a as varBinary(100)),5,1) as varchar(100))
set @a='测试ABCDE'
select cast(substring(cast(@a as varBinary(100)),5,1) as varchar(100))
黨把set @a='测试ABCDE'
select cast(substring(cast(@a as varBinary(100)),5,1) as varchar(100))
改成
set @a='测试ABCDE'
select cast(substring(cast(@a as varBinary(100)),2,1) as varchar(100))
好像就不行了 !