• DECLARE@IPvalue BIGINT = 3222211197,

    @IPstring VARCHAR(15) = '192.15.10.125'

    -- SwePeso (value to string)

    SELECTCAST(CAST(SUBSTRING(Data, 1, 1) AS TINYINT) AS VARCHAR(3))

    + '.' + CAST(CAST(SUBSTRING(Data, 2, 1) AS TINYINT) AS VARCHAR(3))

    + '.' + CAST(CAST(SUBSTRING(Data, 3, 1) AS TINYINT) AS VARCHAR(3))

    + '.' + CAST(CAST(SUBSTRING(Data, 4, 1) AS TINYINT) AS VARCHAR(3)) AS IP

    FROM(

    VALUES(CAST(@IPvalue AS BINARY(4)))

    ) AS d(Data)

    -- SwePeso (string to value)

    SELECTCAST(16777216E * PARSENAME(@IPstring, 4)

    + 65536E * PARSENAME(@IPstring, 3)

    + 256E * PARSENAME(@IPstring, 2)

    + 1E * PARSENAME(@IPstring, 1) AS BIGINT) AS IP


    N 56°04'39.16"
    E 12°55'05.25"