仅使用SQL将基36转换为基10

select sum(position_value) from
(
  select power(36,position-1) * case when digit between '0' and '9' 
                                     then to_number(digit)
                                     else 10 + ascii(digit) - ascii('A')
                                end
          as position_value
    from (
          select substr(input_string,length(input_string)+1-level,1) digit, 
                 level position
            from (select '01Z' input_string from dual)
            connect by level <= length(input_string)
         )
)

对于t-sql,下面的逻辑将执行上面的oracle代码所做的任务。这是通用的通用解决方案,将支持base-x到base-10:

select
    sum(power(base,pos-1) *
            case when substring(cnv,pos,1) between '0' and '9' then 
                cast(substring(cnv,pos,1) as int) 
            else 10 + ascii(upper(substring(cnv,pos,1))) - ascii('A') end)
    from (values(reverse('01Z'), 36)) as t(cnv,base)
        left join (values(1),(2),(3),(4),(5),(6)) as x(pos)
            on pos <= len(cnv)

与其他碱基一起使用,只需使用:

from (select cnv = reverse('FF'), base=16) as t

或

from (select cnv = reverse('101'), base=2) as t

请注意,要支持长度超过6的字符串,需要向位置向量添加更多的值。