Text Range Failure?

[Timothy Trimble]

Has anyone run into an issue where a Find for a text range is not working? I have a table with a ShortCode field of 2 to 5 digits, in text. When I try to search for a range ("KE...HRYD") I'm getting 0 records, when it should be returning around 100+ records. Any ideas?

[comment]

Try "HRYD...KE"?

[Timothy Trimble]

Now that was just way too easy and now I'm totally embarrassed! That did the trick. Thanks.

Now I'm curious as to why the range needs to be specified this way (high text to low text)?

[David Jondreau]

http://fmforums.com/forum/showpost.php?post/282581/

[comment]

why the range needs to be specified this way (high text to low text)?

Actually, it needs to be "low text" to "high text" - in alphabetical order, "HRYD" comes before "KE".

I don't know why Filemaker requires the range to be in ascending order. Maybe it has something to do with range finds on cyclic data, such as "Mon...Fri" producing different results than "Fri...Mon".