On Fri, 27 May 2005 06:33:19 -0700, "Chip1035"
That would appear to be correct.
So the query is working exactly as I would expect. The two text
strings are different, therefore they don't match, therefore the
records aren't retrieved!
Remember - you're dealing with a mindless, stupid computer. It can
only take things literally. If you ask "are these the same" about two
strings, it cannot apply human intuition - it can only compare them
byte by byte and say "yes" or "no".
I suspect you could have "A. D. P. Inc." or "ADP Inc" or "Atcheson
Design Professionals Inc." as names for this same company; you or I
can look at these and speculate that they might (or might not!) be the
same, but a computer cannot.
I don't know of anything straightforward that would let you do these
"not quite matches". I suppose you could write VBA code to strip out
everything nonalphanumeric and match on those values (ADPINC frex) but
even that will miss some "matches".
John W. Vinson[MVP]