Yes, but do it like this:
NOT ("%" + $field$ + "%" LIKE 'field')
("%" + $field$ + "%" NOT LIKE 'field') won't work in most languages.
Fluxman
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian
Sent: 03/14/2007 4:23 PM
To: [email protected]
Subject: Can I do a Not Like Search?
**
I have a character field with several rows of numbers. I also have a table
that is displaying all the numbers in the character field that match a
separate table ("%" + $field$ + "%" LIKE 'field'). I also would like a table
that displays any numbers that are not matched. Is there a way to search for
a value that is not like another? If there was a single value in the
character field then this would be easy.
Brian Sokol
Manager, Desktop Services
Scholastic Inc.
557 Broadway
NY, NY 10012
(212) 343-6494
<http://www.Scholastic.com> http://www.Scholastic.com
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
