View Single Post
Old 6th September 2006, 18:35
lbencic's Avatar
lbencic lbencic is offline
Join Date: Dec 2001
Location: Lisle, IL, USA
Posts: 1,148
lbencic will become famous soon enough
Baan: 2.2d - LN - DB: most - OS: most
The difference with 'between' and 'inrange' comes when you are comparing an index with multiple parts (or other combined fields).

Inrange will compare the range for each field in the combined index individually, and Between will apply the range to the combined field all together.

See the WIKI link for further explanation and examples:
Reply With Quote