Solved

MS Access criteria with like function

Posted on 2013-06-17
3
729 Views
Last Modified: 2013-06-17
Hi there,

I am working with MS Access for setting criteria for a Text field. Would like to find a "*" if it occuried inside the text by LIKE function. However I found as the original setting of Like * means match all, I fail to do what I need :

e.g. original MS Access setting is : to find text contains "A" is LIKE "*A*"

However, what I need now is to find text contains "*"...........

Pls anybody help?
0
Comment
Question by:hkgal
3 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39252704
Hi

Like "[*]"

Regards
0
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 39252707
If the field contains just an asterisk then set the criteria as
"[*]"

If the field contains other characters as well as an asterisk then use..

Like "*[*]*"
0
 

Author Closing Comment

by:hkgal
ID: 39255046
thanks excellent
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

778 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