Use of Wildcard in Query

[surfbum3000]

I have 2 tables:
tblCaseNos
tblLongDrive
Joins: [tblCaseNos.Name] = [tblLongDrive.Name]

I want to add tblCaseNos.CaseNo to the table tblLongDrive to create a new table with the CaseNo.

The problem is the names are not exact in both tables. The tblCaseNos has Middle Name, Suffix (eg. III), etc. and the tblLongDrive has only LastName, FirstName. How can I query the name using a wildcard?

 

[surfbum3000]

Here is the answer:

LastName: Left([Name],InStr([Name],", ")-1)

FirstName: Mid([Name],InStr([Name]," ")+1)

This works for Name in table entered as LastName, FirstName