/****** Object:  User Defined Function dbo.ServerAddrToStr    Script Date: 12/1/2005 11:50:35 PM ******/
CREATE function ServerAddrToStr(@address varchar(32))
returns varchar(128)
AS
BEGIN
    /* input address has format of 8a2a9911 */
    DECLARE @result varchar(128)
        ,@inputSize int
        ,@i int
    SET @inputSize = len(@address)
    SET @result = ''
    SET @i = 1
    WHILE (@i < @inputSize) BEGIN
        SELECT @result = @result +
            convert(varchar(5), 1000+convert(int,intValue))
            FROM Hex2Decimal
            WHERE substring(@address, @i,2) = hexValue
        SET @i = @i + 2
        if (@i < @inputSize) BEGIN
            SET @result = @result + '.'
        END
    END
    WHILE (@i < 20) BEGIN
        SET @result = '1000.'+@result
        SET @i = @i + 2
    END
return @result
END
GO