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"