help with deleting initial characters from field

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

Hi,
I am trying to check 1 table against another for unmatched
records, using a name field. In Table 1 the name field
contains first and last name, e.g. John Smith. In Table 2,
some (but not all) of the records also contain a title
e.g. Dr John Smith.
Any ideas on how to strip these titles from the beginning
of the field?
Thanks, Richard
 
Hi,


Yep. That would find rows in table1 with a name not like any name in table2



SELECT table1.*
FROM table1 LEFT JOIN table2
ON table2.name LIKE "*" & table1.Name & "*"
WHERE table2.Name Is Null



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top