MSSQL 2000 - Convert varchar hex value to integer (need to remove 0x prefix before calling)

fn_HexToInt.sql

CREATE FUNCTION fn_HexToInt( @HexValue VARCHAR(20) )
RETURNS INTEGER
AS
BEGIN

DECLARE @iOutput INTEGER
DECLARE @sChar   CHAR(1)
DECLARE @iChar   INT

SET @iOutput = 0
SET @iChar = 0

WHILE @iChar < LEN(@HexValue)
  BEGIN
     SET @sChar = SUBSTRING(@HexValue,(LEN(@HexValue) - @iChar),1)

     SET @iOutput = @iOutput + (POWER(16,(@iChar)) * (
          CASE
          WHEN ISNUMERIC(@sChar) = 1 THEN CONVERT(INT,@sChar)
          WHEN @sChar = 'A' THEN 10
          WHEN @sChar = 'B' THEN 11          
          WHEN @sChar = 'C' THEN 12
          WHEN @sChar = 'D' THEN 13
          WHEN @sChar = 'E' THEN 14
          WHEN @sChar = 'F' THEN 15
          END
     ))
     -- Chop off the digit we just processed
     SET @iChar = @iChar + 1
  END

RETURN @iOutput

END