Home All Groups Group Topic Archive Search About
Author
21 May 2006 8:23 PM
Niclas
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

Author
22 May 2006 3:49 PM
aaron.kempf@gmail.com
you can use the parsename function in sql server to do this.

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

etc