I just wrote this, but it should work.

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