is between inclusive or exclusive? in other words wouldn't it be written 'between 10 and 19' for values 10 from 19 instead of 'between 9 and 20' for 10 to 19?
makes more sense if it's inclusive, imho i've only seen BETWEEN used in uniquery before so..... -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: Tuesday, April 17, 2012 10:19 PM To: U2 Users List Subject: Re: [U2] BETWEEN operator the point is that rather than the cumbersome way we have always written the GE LE statement, there might be a better way... that makes readability better and will take you 3425.6 man hours to implement throughout your system.. however I have no idea what I'm talking about here On 18 April 2012 11:16, Allen Egerton <aeger...@pobox.com> wrote: > So what was/is your point? > > 'cause I'm like the other Allen, sitting here wondering what it is > that you're asking or responding to... > > > > On 4/17/2012 9:08 PM, Wjhonson wrote: > > There is no question. > > > > > > > > -----Original Message----- > > From: Allen Elwood RR <aelw...@socal.rr.com> > > To: U2 Users List <u2-users@listserver.u2ug.org> > > Sent: Tue, Apr 17, 2012 6:01 pm > > Subject: Re: [U2] BETWEEN operator > > > > > > did u hit send b4 the question? > > On 4/17/2012 5:46 PM, Wjhonson wrote: > > Pick BASIC > > > > IF MYVALUE> 9 AND MYVALUE< 20 THEN... > > > > or > > > > IF 9< MYVALUE< 20 THEN ... > > > > or > > > > IF BETWEEN(MYVALUE,9,20) THEN ... > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users