Asterisk (*) is for wildcard and can be used anywhere in the text
- *end
- start*
- Start*end
- *contains*
Exclamation/Bang (!) – used for exclusion
- !happy (not happy exactly)
- !happy* (not anything starting with happy)
Plus/minus (+/-)
- Used with date fields to get Days Back, i.e. 0-7 provides last 7 days.
- Used with date fields to get items in future, such as Open Houses, i.e. 0+7 provides OH’s in next 7 days.
- Used for ranges, i.e. 4-5 bedrooms.
- Used for Greater than or equal to, i.e. 5+ returns more than or equal to 5.
- Used for Less than or equal to, i.e. 5- returns less than or equal to 5
Comma – Used to allow multiple entries in search
- 4, 5, 6-10
- Bob, Mary
- Smith, “Smith, Jr.”, Jones (item with comma in the field should be enclosed in quotes)
Combining – You can combine the above items in one control, but be careful it isn’t so complex that nothing is in the results.