Get the Value of a BitMask

create function dbo.fnBitMaskToInt
(
@Bits varchar(64)
)
returns int
as
begin
declare @Value int
declare @i int
declare @length int
declare @CurChar char
set @value = 0

set @length = len(@bits)
set @i = 0
while @i < @length
begin
set @curchar = left(@bits,1)
set @bits = right(@bits,len(@bits)-1)

if @curchar = '1'
begin
set @value = @value + power(2,@i)
end
set @i = @i + 1
end

return @value
end