Translations:Faq/Base/115/10/en
- for an exact match search, type the word (Base automatically adds single quotes)
- for a partial match search, use the keyword LIKE and then enclose your entry between percent signs ("%")
- to allow the search to match the entered string in either upper or lower case (ie case insensitive), the field definition must have type definition "VARCHAR_IGNORECASE"