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