IP Subnet Test

's Computer Specifications

Hi,

Does anyone have some code that would allow me to test if a specific IP
address is within a specific IP range or a distinct subnet or similar ?

Any help appreciated.

Thanks

Niclas

's Computer Specifications

you can use the parsename function in sql server to do this.

parsename(@myIP, 3) = '192' AND parsename(@myIP, 2) = '168'

etc

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cannot ping from subnet A to subnet B for a specific host	soup_or_power@yahoo.com	Microsoft Windows 2000 DNS	2	9th Aug 2006 05:20 PM
can't see local subnet, but can see other subnet when browsing	=?Utf-8?B?bW90aWU=?=	Microsoft Windows 2000 DNS	7	28th Feb 2005 06:15 PM
issues with installing DC in Subnet A then moving it to Subnet B?	Scott Townsend	Microsoft Windows 2000 Active Directory	2	24th Feb 2005 04:48 AM
w95 workgroup subnet - w2k domain subnet; shares?	woof	Microsoft Windows 2000 Networking	4	20th Apr 2004 02:09 PM
2003 Server in subnet A can't join W2k domain with DCs in subnet B	Timothy Kidd	Microsoft Windows 2000 Networking	1	8th Jan 2004 04:38 PM