Using Like to Join Tables (MS Access)

Key:

  1. Use Regular Express
  2. Use Instr function

Example:

Reference: