Using the query to filter out the specifics

10 pts.
Tags:
Query
Hello, i was just wondering if there is any way to use the query to filter out all the list with the word "mexT" in their lines/box. For example, in the column, there are bunch of lines with lines such as "cexT3df3#", aextT3rdfad" "mexT124ef3" "mexT235tgc#", etc.... but not exactly just mexT. How can i use the query to filter out all the lines with mexT in them?

Answer Wiki

Thanks. We'll let you know when a new response is added.

NLIKE ‘%mexT%’ Case sensitive

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JennyMack
    Hi there, Welcome to the IT Knowledge Exchange community. Can you please specify what program you are using? Thanks, Jenny Community Manager
    4,280 pointsBadges:
    report
  • SpyMoose
    There is usually a 'wild card' for the OS that you are using, try plugging that in to the query filter before and after the "meT" segment. Example: For Access databases the filter string would look like *meT* which would include anything with meT anywhere in the line you want to filter out so12meTase, meT302, and 860meT would all be filtered. If you add the wild card after the string only items starting with meT would be filtered. If you aren't using windows software I'm not too sure what your wild card would be. It also may be a proprietary symbol to the software, a few of the programs I've used changed the wild card from "*" to "%" for an unknown reason.
    625 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following