what about using NSELECT with MULTI.VALUE.ATT = "DOG" This won't select any that have a value = DOG.
George >-----Original Message----- >From: Adrian Matthews [mailto:[EMAIL PROTECTED] >Sent: Tuesday, August 24, 2004 12:43 PM >To: [EMAIL PROTECTED] >Subject: RE: [U2] [UV] The Learning Curve Continues!! > > >EVERY is a keyword in Universe that will do what you want. >From HELP EVERY. > > >| > | Use in a selection expression to select a record only if every >| > | value in a multivalued field meets the specified condition. >| > | EVERY must be used with the WITH keyword. For example: >| > | >| > | >LIST INVENTORY WITH EVERY ITEM EQ 'PAPER' > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of David >Wolverton >Sent: 24 August 2004 17:29 >To: [EMAIL PROTECTED] >Subject: [U2] [UV] The Learning Curve Continues!! > >I just found out the reason LIKE is misbehaving for me is that I'm >'Quoting' >is and should not be.... > >The ellipses act like quotes... Got it... > >Now ... How do I find records in UV with this statement in UD? > >SELECT FILE WITH EVERY MULTIVALUE.ATTB # "DOG" > >Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want >that >record selected... > >I can't find 'each' or 'every' as key words in RetriVe... >------- >u2-users mailing list >[EMAIL PROTECTED] >To unsubscribe please visit http://listserver.u2ug.org/ > > >The information contained in this email is strictly >confidential and for the use of the addressee only, unless >otherwise indicated. If you are not the intended recipient, >please do not read, copy, use or disclose to others this >message or any attachment. Please also notify the sender by >replying to this email or by telephone +44 (0)20 7896 0011 and >then delete the email and any copies of it. Opinions, >conclusions (etc.) that do not relate to the official business >of this company shall be understood as neither given nor >endorsed by it. IG Markets Limited and IG Index Plc are >authorised and regulated by the Financial Services Authority >and, in Australia, by the Australian Securities and >Investments Commission. >------- >u2-users mailing list >[EMAIL PROTECTED] >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
