基于SQL的36进制转10进制函数

ALTER FUNCTION [dbo].[Convert36To10]

(

@str varchar(2)

)

RETURNS int

AS

BEGIN

DECLARE @X36 varchar(36);

DECLARE @rstr varchar(2);

DECLARE @rchar varchar(1);

DECLARE @idx int;

DECLARE @val int;

DECLARE @jval int;

set @X36 = '0123456789ABCDEFGHIJHKLMNOPQRSTUVWXYZ';

set @val = 0;

set @jval =1;

set @rstr = REVERSE(@str);

while (len(@rstr) >= 1)

begin

set @rchar = SUBSTRING(@rstr,1,1);

set @val = @val + (CHARINDEX(@rchar,@X36 COLLATE Latin1_General_CS_AS)-1)*@jval ;

set @rstr = SUBSTRING(@rstr,2,len(@rstr)-1);

set @jval = @jval * 36 ;

end

return @val;

END