From The Document Foundation Wiki
Jump to navigation Jump to search
  • 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"