IP Address to IP Value
376519Apr 10 2007 — edited Apr 11 2007Hello
I am trying to convert a MSSQL Function that would take a IP Address (192.168.200.146) and return its numerical value (-1832343360).
Any help would be great!
The MSSQL Function is:
CREATE FUNCTION OctetsToIPValue
(
@octet1 TINYINT,
@octet2 TINYINT,
@octet3 TINYINT,
@octet4 TINYINT
)
RETURNS INT
AS
BEGIN
DECLARE
@Result INT,
@BValue BINARY(4)
SET @BValue =
CAST( @octet4 AS BINARY(1)) +
CAST( @octet3 AS BINARY(1)) +
CAST( @octet2 AS BINARY(1)) +
CAST( @octet1 AS BINARY(1))
SET @Result = CAST(@BValue AS INT )
RETURN @Result
END