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

Reply via email to