View Single Post
  #4  
Old 7th September 2006, 18:45
jcasanov jcasanov is offline
Junior Member
 
Join Date: Oct 2005
Posts: 23
jcasanov is on a distinguished road
Baan: BaaN IV B40c.66 - DB: Informix 9.21 - OS: Windows NT 4
not in

Quote:
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,
Jaime Casanova
Reply With Quote