Wildcard characters work only in fields that contain text.
They do not work in fields that contain dates or numbers. It is also possible to combine Boolean operators with wildcards. The difference with a Boolean search is that with a Boolean search you can define exactly what you are looking for while using a wildcard you might retrieve results you are not interested in at all. Proximity operators You can focus a search more closely by using proximity operators. The NEAR operator finds documents matching specified search terms within close proximity to each other.