I've got a question here that has me scratching my head - I've got a table of IP addresses. Each octet has its own field (OCT1,OCT2,OCT3,OCT4).
The first two octets are fixed, and will never change (so, the IP addresses on my table are between X.Y.0.0 and X.Y.255.255). As such, I've got a range form where the user can type in the third and fourth octets of the low and high IP search range.
The problem is, is I can't figure out the proper format of the SELECT statement. I've tried a bunch of ideas and looked up several resources, but haven't been able to put something together that works.
Can anyone come up with any suggestions?