Using 'Wildcard' characters in a Search

The Similar To search type for a field matches the supplied word within a text block of any length, and so is the preferred type for a text field.

For a Similar To search, you can get even more flexibility if the keyword contains wildcard characters.

The available wildcard characters are as follows:

An underscore character [ _ ] matches any single character in the position of the underscore so that for example:

Similar To
h_t will match the words 'hat', 'hit', 'hut', 'hot'

Similar To
left_handed will match the words 'left-handed', 'left handed'

A percent character [ % ] matches multiple characters in the position of the % character so that for example:

Similar To h%t

will match records wherever the fragment heat is found within the field. heater, heather, heating ... etc.

Caution: You should try to avoid wildcard searches that will match a large number of records.

Similar To	h_t	will match the words 'hat', 'hit', 'hut', 'hot'
Similar To	left_handed	will match the words 'left-handed', 'left handed'