AnsweredAssumed Answered

Table relationship based on IP address and wild cards possible?

Question asked by gewald on Apr 1, 2011
Latest reply on Apr 6, 2011 by gewald

Title

Table relationship based on IP address and wild cards possible?

Post

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). 

Outcomes