I suspect that since TYPE is a mutlivalued field, some records have CREDIT in one value and something else in another value. Given that every record meets the TYPE # "CREDIT" condition, I would take a careful look at the data to see if there is a stray value mark in every record resulting in an apparent extra value.
The WITH clause says at least one element must meet the condition. The WITH EVERY clause may help depending on what you are trying to do. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 ----- Original Message ----- From: "George Gallen" <[EMAIL PROTECTED]> To: "'Ardent List'" <[EMAIL PROTECTED]> Sent: Monday, February 02, 2004 9:41 PM Subject: SELECT NOT WORKING [uv 10 - unix] > OK....What gives. > > GET-LIST MYLIST > > 253 ITEMS SELECTED > >SELECT FILE WITH TYPE # "CREDIT" > 253 ITEMS SELECTED > > > > > > BUT.... > > GET-LIST MYLIST > > 253 ITEMS SELECTED > >SELECT FILE WITH TYPE = "CREDIT" > 10 ITEMS SELECTED _______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
