Boolean search logic in Advanced Find [Contacts]

  • Thread starter Thread starter Paul Travis
  • Start date Start date
P

Paul Travis

Hi there -- I'm trying to find all contacts whose Notes have string
"AAA" but not "BBB". The two ways I've tried thus far are
unsuccessful:

1) Advanced Find - Notes CONTAINS "AAA"
Notes DOESN'T CONTAIN "BBB"

2) Advanced Find - Notes CONTAINS "(AAA) AND NOT (BBB)"

I think it might be easy to do with the Contact View Filter by SQL but
I can't quite get the syntax. Any other suggestions for making this
happen? Thanks in advance!

pt
 
Hi there -- I'm trying to find all contacts whose Notes have string
"AAA" but not "BBB". The two ways I've tried thus far are
unsuccessful:

1) Advanced Find - Notes CONTAINS "AAA"
Notes DOESN'T CONTAIN "BBB"

2) Advanced Find - Notes CONTAINS "(AAA) AND NOT (BBB)"

I think it might be easy to do with the Contact View Filter by SQL but
I can't quite get the syntax. Any other suggestions for making this
happen? Thanks in advance!

pt
Click to expand...

Come on, NO MVP out there can answer this one? :)
 
Back
Top