Hi, one question, when you say "fuzzy" search, how fuzzy are we talking? Would the text be the same for each account name with different cases, or would some be completely different? For example it is pretty easy to compare: Table1 - Account Name1 to Table2 - account name1
However if you are comparing something like: Table 1 - Account Name1 to Table2 - Acct. name 1, that can be a bit more difficult.
no fuzzy compare is going to put those two together. That would be a manual one. You could use except, then once you see the type of data you get back then you might be able to apply some logic or soundex function to it. Been awhile since I messed with soundex, but I think you should be able to say above nth of a match.