Solved

Querying for *

Posted on 2014-02-05
4
140 Views
Last Modified: 2014-02-07
I am trying to query for the * symbol within records and am having trouble with the usual way I would do this since the * is part of like "*(some value)*" that I would usually use. Any ideas?  Thanks!
0
Comment
Question by:daisypetals313
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 35

Expert Comment

by:mvidas
ID: 39836592
You should be able to query for [*] to find the literal asterisk instead of the wildcard.
Matt
0
 

Author Comment

by:daisypetals313
ID: 39836638
The * is mixed in with other characters so I need the like part
0
 
LVL 35

Accepted Solution

by:
mvidas earned 500 total points
ID: 39836653
What about using     *[*]*     in the Like. In the past I've written it as "*" & "[*]" & "*" to make it easier to understand later, but either should be good for what you need.
0
 

Author Closing Comment

by:daisypetals313
ID: 39841482
Thanks! I used *[*]* and it worked perfect.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question