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!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Select using NOT Instr? 1
- Thread starter mgallot
- Start date
-
1
- #2
Just change the sign in the formula, e.g.,
instr({table.string},"ABC") = 0
However, it would be better to use the following in a record selection formula:
not({table.string} like "*ABC*")
...as this will pass to the SQL, resulting in a speedier report.
-LB
instr({table.string},"ABC") = 0
However, it would be better to use the following in a record selection formula:
not({table.string} like "*ABC*")
...as this will pass to the SQL, resulting in a speedier report.
-LB
- Status
Similar threads
- Locked
- Question