This one time, at band camp, John Stanton <[EMAIL PROTECTED]> wrote:
> It looks as if you are looking to see if an address belongs to a > particular class B network. Are all your searches done that way? > > If they are you may be able to use a regular expression to do your search. well, the range could be 256, or 16, or 131072 or 2048 or any other number really. but the IP will always be a valid IPv4 address. Given a valid IPv4 address, I wish to find the range it falls into. eg: SELECT * FROM table WHERE start < 203.7.136.123 AND 203.7.136.123 < (start plus range); I guess the main issue is getting the start value plus the range value. Kind regards Kevin -- "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
