/****** Object:  Stored Procedure dbo.tng_iphex2str_nd    Script Date: 12/1/2005 11:49:13 PM ******/


CREATE procedure tng_iphex2str_nd @ipaddr_hex binary(4), @ipaddr_str varchar(15) OUTPUT
as
    if (@ipaddr_hex = NULL)
        select @ipaddr_str = NULL
    else
    begin
        select @ipaddr_str = ltrim(str(convert(int,substring(@ipaddr_hex, 1, 1)))) + '.' +
            ltrim(str(convert(int,substring(@ipaddr_hex, 2, 1)))) + '.' +
            ltrim(str(convert(int,substring(@ipaddr_hex, 3, 1)))) + '.' +
            ltrim(str(convert(int,substring(@ipaddr_hex, 4, 1))))
    end
GO
GRANT EXECUTE ON  [dbo].[tng_iphex2str_nd] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[tng_iphex2str_nd] TO [wvadmin]
GO