Search Database field containing keywords in any order

[jimed99]

Here’s a couple of ideas:

DataView Filter Contains

Hi, I am using a data view with a search field, I want to display all rows that contains the text being searched. What should be under my Filter field? "Column 1 == "search term" || Column2 =="search term" works when I need the exact value. However, I want to replace == with contains or fuzzy search, how can I do that?

Fuzzy Search little problem

Is there a way to get the fuzzy search to show results no matter if there is a capital letter or not. For example in the DB I have Albert Now if I search with fuzzy search for Albert then it works, but if search for albert it does not show. Anyone got any ideas?