[U2] Weird SELECT Behavior - GE on @ID

2011-12-30 Thread John Thompson
I have seen this behavior on Universe 10.3.4 on AIX as well as Universe 11.1.4 on Linux. These are PICK flavor accounts. Consider a file with a key like so: 2011061 2011062 SELECT FILENAME = 201106] SELECT FILENAME GE 201106] SELECT FILENAME WITH @ID = 201106] SELECT FILENAME WITH @ID

Re: [U2] Weird SELECT Behavior - GE on @ID

2011-12-30 Thread Martin Phillips
Hi John, I may be wrong but I believe that the Pick style wildcards only work in string equality tests. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: John Thompson Sent: Friday,