-- Stored/used as tinyint/int/bigint CREATE PROCEDURE save_something (@ip_address varchar(15) ) AS Begin Declare @ip3 int Declare @ip2 int Declare @ip1 int Declare @ip0 int -- characters other than digits and dots If @ip_address LIKE '%[^.0-9]%' RETURN 1 -- different number of dots then 3 If LEN(@ip_address) - LEN(REPLACE(@ip_address, '.', '')) <> 3 RETURN 1 -- missing octets If @ip_address NOT LIKE '%_%.%_%.%_%.%_%' RETURN 1 -- first octet between 0 and 255 SELECT @ip3=LEFT(@ip_address, CHARINDEX('.',@ip_address) - 1) If @ip3 NOT BETWEEN 0 AND 255 RETURN 2 -- second octet between 0 and 255 SELECT @ip2=SUBSTRING(@ip_address, CHARINDEX('.', @ip_address) + 1, CHARINDEX('.', @ip_address, CHARINDEX('.', @ip_address) + 1) - CHARINDEX('.', @ip_address) - 1) If @ip2 NOT BETWEEN 0 AND 255 RETURN 2 -- third octet between 0 and 255 SELECT @ip1=SUBSTRING(@ip_address, CHARINDEX('.', @ip_address, CHARINDEX('.', @ip_address) + 1) + 1, (LEN(@ip_address) - CHARINDEX('.', REVERSE(@ip_address)) + 1) - (CHARINDEX('.', @ip_address, CHARINDEX('.',@ip_address) + 1)) - 1) If @ip1 NOT BETWEEN 0 AND 255 RETURN 2 -- fourth octet between 0 and 255 SELECT @ip0=RIGHT(@ip_address, LEN(@ip_address) - (LEN(@ip_address) - CHARINDEX('.', REVERSE(@ip_address)) + 1)) If @ip0 NOT BETWEEN 0 AND 255 RETURN 2 -- the IP address is valid. @ip3, @ip2, @ip1, @ip0 now contain the 4 octects -- and can be stored as tinyint or compared to tinyint. ... do your thing End RETURN 0
Declare @ip_bigint bigint Set @ip_bigint=(((CAST(@ip3*256 AS bigint)+@ip2)*256)+@ip1)*256+@ip0 -- example: 193.0.0.1 = 3238002689
Declare @ip_int int Set @ip_int=(@ip3&254)*256*256*128+((@ip3&1)*256*256*256*-128)+@ip2*256*256+@ip1*256+@ip0 -- example: 193.0.0.1 = -536870911
Declare @ip_binary binary(4) Set @ip_binary=CAST(CHAR(@ip3)+CHAR(@ip2)+CHAR(@ip1)+CHAR(@ip0) as binary(4)) -- example: 193.0.0.1 = 0xC1000001
CREATE FUNCTION dbo.ip_address_to_int (@ip_address varchar(15) ) RETURNS int WITH SCHEMABINDING AS Begin Declare @ip3 int Declare @ip2 int Declare @ip1 int Declare @ip0 int If @ip_address LIKE '%[^.0-9]%' RETURN NULL If LEN(@ip_address) - LEN(REPLACE(@ip_address, '.', '')) <> 3 RETURN NULL If @ip_address NOT LIKE '%_%.%_%.%_%.%_%' RETURN NULL SELECT @ip3=LEFT(@ip_address, CHARINDEX('.',@ip_address) - 1) If @ip3 NOT BETWEEN 0 AND 255 RETURN NULL SELECT @ip2=SUBSTRING(@ip_address, CHARINDEX('.', @ip_address) + 1, CHARINDEX('.', @ip_address, CHARINDEX('.', @ip_address) + 1) - CHARINDEX('.', @ip_address) - 1) If @ip2 NOT BETWEEN 0 AND 255 RETURN NULL SELECT @ip1=SUBSTRING(@ip_address, CHARINDEX('.', @ip_address, CHARINDEX('.', @ip_address) + 1) + 1, (LEN(@ip_address) - CHARINDEX('.', REVERSE(@ip_address)) + 1) - (CHARINDEX('.', @ip_address, CHARINDEX('.',@ip_address) + 1)) - 1) If @ip1 NOT BETWEEN 0 AND 255 RETURN NULL SELECT @ip0=RIGHT(@ip_address, LEN(@ip_address) - (LEN(@ip_address) - CHARINDEX('.', REVERSE(@ip_address)) + 1)) If @ip0 NOT BETWEEN 0 AND 255 RETURN NULL RETURN (@ip3&254)*256*256*128+((@ip3&1)*256*256*256*-128)+@ip2*256*256+@ip1*256+@ip0 End
ALTER TABLE test ADD CONSTRAINT CK_test_ipaddress CHECK ( ip_address LIKE '%_.%_.%_.%_' -- 3 periods and no empty octets AND ip_address NOT LIKE '%.%.%.%.%' -- not 4 periods or more AND ip_address NOT LIKE '%[^0-9.]%' -- no characters other than digits and periods AND ip_address NOT LIKE '%[0-9][0-9][0-9][0-9]%' -- not more than 3 digits per octet AND ip_address NOT LIKE '%[3-9][0-9][0-9]%' -- NOT 300 - 999 AND ip_address NOT LIKE '%2[6-9][0-9]%' -- NOT 260 - 299 AND ip_address NOT LIKE '%25[6-9]%' -- NOT 256 - 259 )
SELECT * FROM test JOIN validate_ip_address ON test.ip_address LIKE validate_ip_address.valid
CREATE TABLE validate_ip_address (valid varchar(100) NOT NULL) INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].[0-1][0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].2[0-4][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9].25[0-5].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-1][0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].2[0-4][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].25[0-5].[0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].[0-1][0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].2[0-4][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-9][0-9].25[0-5].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-1][0-9][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].2[0-4][0-9].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].25[0-5].[0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].2[0-4][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('[0-1][0-9][0-9].25[0-5].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].[0-1][0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].2[0-4][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('2[0-4][0-9].25[0-5].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].[0-1][0-9][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].[0-9][0-9].[0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].2[0-4][0-9].25[0-5].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-1][0-9][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-1][0-9][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].[0-1][0-9][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].2[0-4][0-9].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].2[0-4][0-9].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].2[0-4][0-9].25[0-5]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].25[0-5].[0-1][0-9][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].25[0-5].2[0-4][0-9]') INSERT INTO validate_ip_address VALUES ('25[0-5].25[0-5].25[0-5].25[0-5]')
-- *** 0.0.0.0/8 Current network (only valid as source address) RFC 1700 *** UPDATE validate_ip_address SET valid='[1-9].'+SUBSTRING(valid,LEN('[0-9].')+1,63) WHERE CHARINDEX('[0-9].',valid)=1 -- 125 rows INSERT INTO validate_ip_address SELECT '0[1-9].'+SUBSTRING(valid,LEN('[0-9][0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('[0-9][0-9].',valid)=1 UPDATE validate_ip_address SET valid='[1-9][0-9].'+SUBSTRING(valid,LEN('[0-9][0-9].')+1,63) WHERE CHARINDEX('[0-9][0-9].',valid)=1 -- 2 x 125 rows INSERT INTO validate_ip_address SELECT '0[1-9][0-9].'+SUBSTRING(valid,LEN('[0-1][0-9][0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('[0-1][0-9][0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '00[1-9].'+SUBSTRING(valid,LEN('[0-1][0-9][0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('[0-1][0-9][0-9].',valid)=1 UPDATE validate_ip_address SET valid='1[0-9][0-9].'+SUBSTRING(valid,LEN('[0-1][0-9][0-9].')+1,63) WHERE CHARINDEX('[0-1][0-9][0-9].',valid)=1 -- 3 x 125 rows -- *** 10.0.0.0/8 Private network RFC 1918 *** INSERT INTO validate_ip_address SELECT '1[1-9].'+SUBSTRING(valid,LEN('[1-9][0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('[1-9][0-9].',valid)=1 UPDATE validate_ip_address SET valid='[2-9][0-9].'+SUBSTRING(valid,LEN('[1-9][0-9].')+1,63) WHERE CHARINDEX('[1-9][0-9].',valid)=1 -- 2 x 125 rows INSERT INTO validate_ip_address SELECT '01[1-9].'+SUBSTRING(valid,LEN('0[1-9][0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('0[1-9][0-9].',valid)=1 UPDATE validate_ip_address SET valid='0[2-9][0-9].'+SUBSTRING(valid,LEN('0[1-9][0-9].')+1,63) WHERE CHARINDEX('0[1-9][0-9].',valid)=1 -- 2 x 125 rows -- *** 127.0.0.0/8 Loopback RFC 3330 *** INSERT INTO validate_ip_address SELECT '12[0-689].'+SUBSTRING(valid,LEN('1[0-9][0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[0-9][0-9].',valid)=1 UPDATE validate_ip_address SET valid='1[013-9][0-9].'+SUBSTRING(valid,LEN('1[0-9][0-9].')+1,63) WHERE CHARINDEX('1[0-9][0-9].',valid)=1 -- 2 x 125 rows -- *** 169.254.0.0/16 Link-Local RFC 3927 *** INSERT INTO validate_ip_address SELECT '16[0-8].'+SUBSTRING(valid,LEN('1[013-9][0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[013-9][0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '169.[0-9].'+SUBSTRING(valid,LEN('1[013-9][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[013-9][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '169.[0-9][0-9].'+SUBSTRING(valid,LEN('1[013-9][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[013-9][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '169.[0-1][0-9][0-9].'+SUBSTRING(valid,LEN('1[013-9][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[013-9][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '169.2[0-4][0-9].'+SUBSTRING(valid,LEN('1[013-9][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[013-9][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '169.25[0-35].'+SUBSTRING(valid,LEN('1[013-9][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[013-9][0-9].[0-9].',valid)=1 UPDATE validate_ip_address SET valid='1[01345789][0-9].'+SUBSTRING(valid,LEN('1[013-9][0-9].')+1,63) WHERE CHARINDEX('1[013-9][0-9].',valid)=1 -- 125, 5 x 25, 125 rows -- *** 172.16.0.0/12 Private network RFC 1918 *** INSERT INTO validate_ip_address SELECT '17[0-13-9].'+SUBSTRING(valid,LEN('1[01345789][0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.[0-9].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.[04-9][0-9].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.0[04-9][0-9].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.1[0-5].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.01[0-5].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.3[2-9].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.03[2-9].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.1[0-9][0-9].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.2[0-4][0-9].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 INSERT INTO validate_ip_address SELECT '172.25[0-5].'+SUBSTRING(valid,LEN('1[01345789][0-9].[0-9].')+1,63) FROM validate_ip_address WHERE CHARINDEX('1[01345789][0-9].[0-9].',valid)=1 UPDATE validate_ip_address SET valid='1[0134589][0-9].'+SUBSTRING(valid,LEN('1[01345789][0-9].')+1,63) WHERE CHARINDEX('1[01345789][0-9].',valid)=1 -- 125, 10 x 25, 125 rows -- *** 255.255.255.255 Broadcast *** INSERT INTO validate_ip_address SELECT '255.'+SUBSTRING(valid,LEN('25[0-5].')+1,63) FROM validate_ip_address WHERE CHARINDEX('25[0-5].',valid)=1 UPDATE validate_ip_address SET valid='25[0-4].'+SUBSTRING(valid,LEN('25[0-5].')+1,63) WHERE CHARINDEX('25[0-5].',valid)=1 INSERT INTO validate_ip_address SELECT '255.255.'+SUBSTRING(valid,LEN('255.25[0-5].')+1,63) FROM validate_ip_address WHERE CHARINDEX('255.25[0-5].',valid)=1 UPDATE validate_ip_address SET valid='255.25[0-4].'+SUBSTRING(valid,LEN('255.25[0-5].')+1,63) WHERE CHARINDEX('255.25[0-5].',valid)=1 INSERT INTO validate_ip_address SELECT '255.255.255.'+SUBSTRING(valid,LEN('255.255.25[0-5].')+1,63) FROM validate_ip_address WHERE CHARINDEX('255.255.25[0-5].',valid)=1 UPDATE validate_ip_address SET valid='255.255.25[0-4].'+SUBSTRING(valid,LEN('255.255.25[0-5].')+1,63) WHERE CHARINDEX('255.255.25[0-5].',valid)=1 UPDATE validate_ip_address SET valid='255.255.255.25[0-4]'+SUBSTRING(valid,LEN('255.255.255.25[0-5]')+1,63) WHERE CHARINDEX('255.255.255.25[0-5]',valid)=1 -- 2 x 125, 2 x 25, 2 x 5, 1 row
Back to SQL Server main menu. Mail your comments to gertjans@xs4all.nl.