find method criteria

[thuy nguyen]

A non-null value in criteria[n] matches any field
value that begins with criteria[n]. (For example, "Fred" matches "Fred" or "Freddy".)

Should we trim() the criteria in the find method? Otherwise " Fred " would not match either "Fred" of "Freddy"

[Jethro Borsje]

The requirements are not clear with respect to trimming the criteria, so I guess you should just do what feels right to you. In my implementation I chose not to trim the criteria, because that might yield unwanted results for the user, consider the following case:

Criteria: "Air "
Data set:
[1] - "Air"
[2] - "Airfield"
[3] - "Air Miles"

With the given criteria the user expects to only find [3], but if you trim the criteria you would also get [1] & [2], because the both begin with "Air".