Thanks Axton. I've not used NOT before. Your example does work querying the incident form, etc. But does not work on my vendor form (I said view form before, that's incorrect, my fault). Also 'field1' is a character field...
'field1' LIKE "%/%" -- works and returns the expected results. But I want the opposite. NOT 'field1' LIKE "%/%" -- no entries are returned. Anything else I could try? Thanks - Marcelo -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Thursday, March 01, 2012 3:24 PM To: arslist@ARSLIST.ORG Subject: Re: query help NOT 'field1' LIKE "%/%" On Thu, Mar 1, 2012 at 3:21 PM, Martinez, Marcelo A <marc...@cpchem.com> wrote: > ** > I've drawn a blank.. need help creating a query. > > I have a field (field1) on a view form that I want to search for all records > that do not contain symbol "/" (forward slash). > Example of data in field: > ABC/123 > ABB > ABC/345 > DEF/555 > DEF > XY > > I only need the query to return ABB, DEF, XY. > > I can do 'field1' LIKE "%/%" ---but how do I do the opposite? > > I've tried: 'field1' != "%/%" ---this does not work. > > > Thanks for the help, > Marcelo > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"