I want search all records with not matching two keyword (CLOS & CANS) like:
1. ADVG XCLT QRPR
2. ADVG CLOS QRPR
3. ADVG CLOS CANS
4. ADVG PQRS QRPR
from the 4 rows I want to display first and last rows. Rows having two word like CLOS and CANS shall not be display.
So, I want to know which keyword I shall use in query function. Not Includes function work only on keyword. But this query have more than one keyword. Please advice.
Discussion posts and replies are publicly visible