Querying for *

Posted on 2014-02-05
Medium Priority
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!
Question by:daisypetals313
  • 2
  • 2
LVL 35

Expert Comment

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

Author Comment

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

Accepted Solution

mvidas earned 2000 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.

Author Closing Comment

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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

600 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