DECLARE @IPAddress VARCHAR(15)
SET @IPAddress = '196.169.25.3'

--Convert to number
SELECT
	CAST(PARSENAME(@IPAddress, 4) AS BIGINT) * POWER(256, 3)
	+ 	CAST(PARSENAME(@IPAddress, 3) AS BIGINT) * POWER(256, 2)
	+ 	CAST(PARSENAME(@IPAddress, 2) AS BIGINT) * POWER(256, 1)
	+ 	CAST(PARSENAME(@IPAddress, 1) AS BIGINT) * POWER(256, 0)

DECLARE @IPAddress VARCHAR(15)
SET @IPAddress = '196.169.25.3'

--Convert to number
SELECT
	CAST(PARSENAME(@IPAddress, 4) AS BIGINT) * POWER(256, 3)
	+ 	CAST(PARSENAME(@IPAddress, 3) AS BIGINT) * POWER(256, 2)
	+ 	CAST(PARSENAME(@IPAddress, 2) AS BIGINT) * POWER(256, 1)
	+ 	CAST(PARSENAME(@IPAddress, 1) AS BIGINT) * POWER(256, 0)

create function dbo.ConvertIp2Num(@ip nvarchar(15))
returns bigint
as
begin
	return ((cast(parsename(@ip,4) as bigint)*256+
             cast(parsename(@ip,3) as bigint))*256+
             cast(parsename(@ip,2) as bigint))*256+
             cast(parsename(@ip,1) as bigint)
end


create function dbo.ConvertNum2Ip(@ip bigint)
returns nvarchar(15)
as
begin
	return  cast(@ip/16777216 as nvarchar(15)) + '.' +
       cast((@ip/65536)%256 as nvarchar(15)) + '.' +
       cast((@ip/256)%256 as nvarchar(15)) + '.' +
       cast(@ip%256 as nvarchar(15))	
end