Jason, Unless UniData 6.0 supports a 'BETWEEN' relational operator, I recommend to you to use the second scenario, "Case (val >= 6000 AND val <= 6009)". I'm using UniData 5.1 and 'BETWEEN' in not a valid relational operator in UniBasic. UniQuery, yes...
Hope this helps! Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] www.bench.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 11:31 AM To: [EMAIL PROTECTED] Subject: BETWEEN in a CASE structure Before I just go off and do this, I thought I'd throw the question out there... In a CASE construct in UniBasic, can you use the BETWEEN keyword to test against a range. For example, I've got a large number of values I'm testing for and several of them are contiguous. Would something like "CASE val BETWEEN 6000 6009" be correct or would I need to do something like "Case (val >= 6000 AND val <= 6009)" be what I need. Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
