'Begins with' search doesn't return suspected results
My DataAssist search is set up for 'includes'. A search for 'red grease' returns all products with 'red grease', 'reduced grease', 'engineered grease', etc.
I switched to 'begins with' but the search for 'red grease' returns 'no records found', as does searches for 'red' and 'grease'. The only way I can get a result for 'grease' is by entering 'g'.
Does the 'begins with' only work with a one word, or one letter, search? Do I have to go back to OR rather than AND in order for two words to work?
I need a search for 'red grease' to return 'red grease' or 'reduced grease' but not 'engineered grease'.