We need to be able to query a column so that the user's input matches the be

We need to be able to query a column so that the user's input matches the beginning of whole words in a column that start with the same value.

For example, a user would type the word "BEA" into a search field, and the results returned from that column would include ("BLACK BEAN", "BEAN BURRITO", "BEAR", etc.) so that it isn't searching on the entire string, but on the words split by a space. The "starts with" in the a!queryrule doesn't allow for that.

We also need to avoid the case where a user types "B" and something like "CARBON FILTER" is returned, since it contains the letter B. The query needs to match the beginning of the whole word.

Any ideas on how we could implement this?

OriginalPostID-152882

OriginalPostID-152882