I am attempting to compare two databases (with over 11000 records in each)
In one table I have a "Sage" generated account reference which uses the first 4 characters of the surname followed by a number if more than one of the same name, the second table has the full surname followed by the chritian name.
I am trying to create an SQL statement (using wildcards) to SELECT the first 4 letters from table 1 and compare them with the first 4 letters from table 2. To then display lists of matching names.
Ideally I would like to be able to SELECT any length of sequence of characters which match any length of the names from any area of the field.
eg Table 1 Account reference = qweABBOTqwe32
Table 2 Name = ABBOT JIMMY
Need to 'Pick out' ABBOT from the field in table 1 to match ABBOT from the field in table 2
PLEASE PLEASE help as I am a beginner at this and it is becoming very frustrating