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"