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"
