SQLite Forum

Help with a search command
Login
Good observation. Depending on the requirements of the OP, it might be sufficient to avoid such cases by defining `all_fields` with a separator. E.g. using a space character : `(fldKey0 || ' ' || fldKey1 || ' ' || fldKey2)`