The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as I can see anyway. Unless they *just* put it into 11.9999 or something
-----Original Message----- From: Martin Phillips <[email protected]> To: U2 Users List <[email protected]> Sent: Wed, Apr 18, 2012 11:46 am Subject: Re: [U2] BETWEEN operator Hi, UV's BETWEEN operator is in the query processor. The previous discussions appear o be looking for it as a Basic operator. Martin Phillips On 18 Apr 2012, at 18:15, Wjhonson <[email protected]> wrote: > Are you saying that Universe has a between operator somewhere? Where? I don't see it. -----Original Message----- From: Brian Leach <[email protected]> To: 'U2 Users List' <[email protected]> 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: [email protected] mailto:[email protected]] 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 [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
