You can use "like" to match parts of a field with % as the wildcard. So like %David% would match fields that contained David somewhere in them. E.g. Davidson, MacDavid etc. You can use it at the end and the start of a phrase David% or %David as well.