DataAssist Search Issue searching with "And"
I have a column that contains for example:
Viola
Violin and Piano
Orchestra
Viola with Orchestra
When I do a search on the above field that includes the word "and" I get no results when there are many results. The generated SQL looks correct: "Search AND (Instruments = 'Viola and Piano')" however, it appears to me the "AND" is causing trouble somewhere. It is only the fields with AND that have this issue. Any thoughts about this?