I have field called price, and I want to set the search option to search between two user input values.
If I search using some operators, less than or greater than for example, the field appears to be recognized as a number and I get a correct result.
When use between, it seems to be matching on a text string.
How can I accomplish searching two input ranges and have it processed as a numeric value? It is a number in the db.
