34,593
社区成员
发帖
与我相关
我的任务
分享
Declare @str varchar(50),@result varchar(50)
set @str='414243313233344B4A'
select
@result=isnull(@result,'')+
char(left(col,1)*16
+case when isnumeric(right(col,1))=0 then ascii(right(col,1))-55 else right(col,1) end
)
from(
select substring(@str,number*2+1,2) as col
from master..spt_values
where type='P' and number<len(@str)/2
) t
select @result as result
/**
result
--------------------------------------------------
ABC1234KJ
(1 行受影响)
**/