Table relationship based on IP address and wild cards possible?
I need to link two tables based on a column of IP addresses in one table with a column using wild cards to represent ranges of addresses using wild cards (like 123.456.789.*). I need that value to link to 123.456.789.1, or .2. or .3 etc), but I can't seem to get it to work. Was hoping there would be a "begins with" relationship since none of my IP addresses have wild cards in the middle of the address (no 123.*.456.789 values).