I'm sure there's a much cleverer query-only way of doing this. But I'd just do a merge list. Select all the records into one list. Select into another all records WITH EVERY FIELD LIKE 'SF...''SH...' Then grab the difference.
Katie Katie Morgan Datatel Programmer/Analyst Linfield College Integrated Technology Services 900 SE Baker St McMinnville, OR 97128-6894 [EMAIL PROTECTED] 503.883.2714 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Jeffrey Butera > Sent: Friday, June 20, 2008 8:26 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Friday query logic > > 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 > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/