Added a view to the DB so that we can sort on the IP address easily:
1 CREATE VIEW IpAddressABCD AS 2 SELECT *, CAST(PARSENAME(IpAddress,4) AS INT) AS A, CAST(PARSENAME(IpAddress,3) AS INT) AS B, CAST(PARSENAME(IpAddress,2) AS INT) AS C, CAST(PARSENAME(IpAddress,1) AS INT) AS D 3 FROM IpPool
