I think you are on the right track with this one, but change the AND to OR. I wanted to include the EVERY keyword before each field but I think that is assumed. SELECT FILE WITH FIELD UNLIKE "SF..." AND FIELD UNLIKE "SH..."
> From: [EMAIL PROTECTED] > To: [email protected] > Subject: [U2] Friday query logic > Date: Fri, 20 Jun 2008 11:25:30 -0400 > > I can't get my head around the proper query logic on this Friday. > > I have a FILE with mv FIELD containing strings. I want to query records where > at least one of the FIELD values doesn't begin with "SF..." or "SH...". > > To be clear: I don't want records if any of the following occurs: > > FIELD = 'SF123' > FIELD = 'SH456' > FIELD = 'SF123':@VM:'SH456' > > but I do want records if any of these occur: > > FIELD='PQ789' > FIELD='SF123':@VM:'XY789' > FIELD='SF123':@VM:'SH456':@VM:'GH789' > > ---------------- > I tried > > SELECT FILE WITH FIELD UNLIKE "SF...""SH..." > and > SELECT FILE WITH FIELD UNLIKE "SF..." AND FIELD UNLIKE "SH..." > > but those include records where FIELD='SF123':@VM:'SH456'. > > Then I tried > > SELECT FILE WITH NO FIELD LIKE "SF...""SH..." > and > SELECT FILE WITH NO FIELD LIKE "SF..." AND NO FIELD LIKE "SH..." > > but that throws out records where FIELD='SF123':@VM:'SH456':@VM:'GH789' which > I need to keep. I've tried some others variants using 'EVERY' but to no > avail. > > So, I'm as a loss short of writing a I-descriptor. Anyone have their logic > cap on today? > > > -- > Jeff Butera, Ph.D. > Administrative Systems > Hampshire College > [EMAIL PROTECTED] > 413-559-5556 > > "Email gives the illusion of progress even when > nothing is happening." unknown > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ _________________________________________________________________ The im Talkathon starts 6/24/08. For now, give amongst yourselves. http://www.imtalkathon.com?source=TXT_EML_WLH_LearnMore_GiveAmongst ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
