Originally Posted by jcasanov
Now my question is because i see in programs a lot of inrange's and (field1 > value_min and field1 < value_max) (for this one i'm prefer between because is more legible) and (field1 <> value and field1 <> value and field1 <> value)... i'm guessing that using between and (in or not in) is not standard in BaaN programs are these constructs low performance? or are there other reasons?
thanks to all who answered me...
but part of my question is still unanswered, what about in and not in... its better to use them or use ORed/ANDed constructions to see if a field does/doesn't contain some list of values?
Thanks in advance,