Search Where Options - This drop-down box allows the user to target how a match is made while searching. The default is ‘anywhere’ within a field.
Click to expand
The following options are available:
Anywhere – This parameter will look for a match on the search term anyplace within the field. For instance, the search term ‘ab’ will return a match for ‘absolute’ and ‘fabulous.’
Start – the start parameter will only look for matches at the beginning of the value. For instance, the search term ‘ab’ will return a match for ‘absolute’ but will not return ‘fabulous.’
End – The end parameter will only look for matches at the end of the value. For instance, the search term ‘ute’ will return a match for ‘absolute’ and ‘salute.’
Entire – The entire parameter requires an exact match on the full term. For instance, the search term ‘absolut’ will not return a match for ‘absolute.’