Hey everyone,
I am currently working with a large data set and am trying to correlate data. In this instance the data is all in the same table. I'd like to query the data for partial matching data. The problem I am having is how the data is formatted in the table. I am querying on IP address. The addresses areIn a table formatted below, how would I write a query to return all results that have matching data? Would it be possible to us a wild card and catch a larger subnet (ie 192.168*)?
Some cells are delimited by semi-colons and contain multiple addresses like this:
123.172.108.71; 152.135.10.142; 111.109.9.134; 34.14.108.76; 161.13.108.77 Some cells only contain one address
10.0.3.1
Thanks for any suggestions!