[Solved] Conversion function in SQL Server
Seems like you want to turn a base36 number into a base10 number. Then you could create a function for base conversion. The function create function dbo.fnBase36ToBase10(@input varchar(8)) returns int as begin declare @base36string varchar(8) = upper(@input); declare @result int = 0; declare @basechars varchar(36) = ‘0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ’; declare @N int = 36; declare @digit char(1); … Read more