How can you compare a part of the name rather than the entire name?

[Andrew Jackson]

SELECT * FROM people WHERE empname LIKE '%ab%'Would return a recordset with records consisting empname the sequence 'ab' in empname.

Hermes Handbags | Hermes Scarf | Hermes Birkin