Is it at all possible to create some sort of fuzzy query to compare a field to a column and return all results that are relatively similar?
Here is an example of what im looking for (the commas are not separators they are part of the strings):
Table1 Field to lookup: fg,,holton,6547APDE...