Hi, UV's BETWEEN operator is in the query processor. The previous discussions appear to be looking for it as a Basic operator.
Martin Phillips On 18 Apr 2012, at 18:15, Wjhonson <wjhon...@aol.com> wrote: > > Are you saying that Universe has a between operator somewhere? > Where? I don't see it. > > > > -----Original Message----- > From: Brian Leach <br...@brianleach.co.uk> > To: 'U2 Users List' <u2-users@listserver.u2ug.org> > Sent: Wed, Apr 18, 2012 10:14 am > Subject: Re: [U2] BETWEEN operator > > > It's also inclusive in (UniVerse and every other) SQL. > Of course, you could always write it as an external function for UniBasic, > hen it can be however you want. 'long as you document it.. > Brian > -----Original Message----- > rom: u2-users-boun...@listserver.u2ug.org > mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips > ent: 18 April 2012 17:29 > o: 'U2 Users List' > ubject: Re: [U2] BETWEEN operator > Hi, > > Yes I would think, if such an operator were to be introduced to Pick BASIC, > hat Between should be exclusive which is how the UniQuery Between (only for > nidata sorry Universe people) works today. "Between 2 and 4" means only 3, > ot 2 and not 4. > > I would disagree, and expect it to be an inclusive range. Perhaps the > ncertainty of semantics is a good reason not to have this as an operator. > > "Give me a number between 1 and 5". I think most people would expect this to > e inclusive. > > > Martin Phillips > adybridge Systems Ltd > 7b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England > 44 (0)1604-709200 > _______________________________________________ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > > ______________________________________________ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://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