Query Criteria - Like*A*

[RAM CHANDRAN]

When I key in the Like*a* in the criteria, Access 2007 always adds an 'A' in
front of Like - It always shows'Alike'

There are dnot results fo this query criteria. Can some help?

Thanks,

RAM CHANDRAN

 

[Lord Kelvan]

When I key in the Like*a* in the criteria, Access 2007 always adds an 'A'in
front of Like - It always shows'Alike'

There are dnot results fo this query criteria. Can some help?

Thanks,

RAM CHANDRAN

try typing in the double quotes as well so it knows what you are
trying to do

like "*A*"

i think the problem is why it is not picking it up automatically is
you are not putting a space after the like so it is treating Like*a*
as a word and since it is not a keyword in access it is thinking it
must be a value in the field so either type

like *a* (Note the space after the word like)

or type it with double quotes and it should to it automatically

hope this helps

 

[Allen Browne]

Try unchecking the 'SQL Server Compatible Syntax (ANSI 92)' option under:
Office Button | Access Options | Object Designers

ALike is undocumented, but it's purpose is explained towards the end of this
page:
http://msdn.microsoft.com/en-us/library/aa140104(office.10).aspx
(In essence you use % rather than * as the wildcard with the ALike
operator.)

 

[RAM CHANDRAN]

I did uncheck the following:

SQL Server Compatible Syntax (ANSI 92)

This Database
Default for new databases

The query returns some of the data, but not all. I will try for some more
time and send another posting of my observation.

Thanks for your help.

RAM CHANDRAN