I have two sets of data that I need to compare but I can't figure out how to do it. First column contains IP addresses 'nnn.nnn.abc.def'. The second column (called name) contains 'name-abc-def'. I need to verify that the last two octets of the IP address match the second part of the name. The problem is that the name will contain zeros while the IP address will not. So I can't use the Replace(Right()) functions to compare the two values since they will have different lengths. For example:
Somehow I would like to show in the query that these two values match. I hope someone can help me with this.