From The Document Foundation Wiki
Jump to: navigation, search
  • Strings should be enclosed in single quotes.
  • In the examples above, and in draft mode, enclosing quotes are not required. They will be added automatically after validation.
  • In draft mode one can also use the wildcard % but it will automatically be replaced with * after validation.
  • In SQL mode, only the % wildcard may be used.