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