View Single Post
  #2  
Old 6th September 2006, 17:35
lbencic's Avatar
lbencic lbencic is offline
Guru
 
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:

http://www.baanboard.com/programmers...ombined_fields
Reply With Quote