CODE: MSSQL convert an IP into a IP number

SELECT (16777216 * CONVERT(float, PARSENAME(URLip, 4)) + 65536 * CONVERT(float, PARSENAME(URLip, 3))) + 256 * CONVERT(float, PARSENAME(URLip, 2))
+ PARSENAME(URLip, 1) ) AS IPNUM
FROM dbo.tbl_IPs