I feel this can be confusing and also requires that the developer anticipate that the user will want to return a result that contains all the records between a set of values. I would like to have an advanced option the uses between or not between clause on a search field and adds and additional control for the second value.

I am attaching a dummy picture of what I mean..

Paul

That would be a very nice and useful enhancement, even though the same concept may apply to other types like Integer and String.

You are right actually it was a decimal value that prompted me to request this, it seemed kind of silly having a >= Gross Wages (Low) and <= Gross Wages (High). not to mention the search list can get really long really fast.