Jeff SELECT DISTINCT @ID TO SLIST 0 FROM UNNEST FILENAME ON FIELD WHERE NOT(FIELD LIKE 'SF%' OR FIELD LIKE 'SH%') ;
The SQL is less of an overhead than doing a by-exp with SAVING UNIQUE @ID in RetrieVe. Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Jeffrey Butera > Sent: 20 June 2008 16:26 > To: [email protected] > 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 > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
