Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there a way to do a lookup for "Does NOT contain" ?

Status
Not open for further replies.
Snakeroot

Snakeroot

Technical User
Joined
Oct 4, 2006
Messages
112
Location
US
I noticed the other day that I can use % as a wildcard when doing an advanced lookup. Is there a way to lookup records for "Does NOT contain %P.O. Box%" ?

SR
 
Sort by date Sort by votes
In ACT! 6, you could put || before the text (or NOT would also work)

I haven't tried this in ACT! 7/8/9, but it tend to use SQL expressions... maybe put an exclamation mark (!) before the first %. The exclamation mark is NOT in SQL.

Let me know if it works or not...

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust
 
Upvote 0 Downvote
I might have a look later... but have a search for "sql expressions" in Google and see if there's a function to try.

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

NicoleMD
  • Locked
  • Question Question
How to fix a "SQL Database instance is unavailble" error in ACT 2012?
Replies
4
Views
1K
GLComputing
GLComputing
siplyconfused
  • Locked
  • Question Question
Adding information to an Act record - Integrating a voice recorder
Replies
1
Views
949
GLComputing
GLComputing
NicoleMD
  • Locked
  • Question Question
Restore a database to a New Computer
Replies
1
Views
882
GLComputing
GLComputing
shelbycobra
  • Locked
  • Question Question
Possible alternatives to E-marketing with Swiftpage
Replies
1
Views
962
GLComputing
GLComputing
Abiztar
  • Locked
  • Question Question
Act deletd notes
Replies
0
Views
1K
Abiztar
Abiztar

Part and Inventory Search

Sponsor

Back
Top