Here is a way I have seen it done by some SQL generators:
('field1' like "%/%") = FALSE Fluxman From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Martinez, Marcelo A Sent: 03/01/2012 4:21 PM To: arslist@ARSLIST.ORG Subject: query help ** 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"