Can I refer to a "*" in a query criteria as text and not a wildcard?

[odin1701]

I don't know if this is possible.

I need to filter on whether the value of a field is "BIN/" or "BIN*" or various other things.

The data is from a mainframe system, and whoever created that was wonderful enough to allow these characters in text fields.

 

[Alansidman]

Yes, but you must enclose them in Brackets. ie. "BIN[/]" or "BIN[*]" If you don't use the brackets then Access treats them as special function characters.

 

[odin1701]

Yes, but you must enclose them in Brackets. ie. "BIN[/]" or "BIN[*]" If you don't use the brackets then Access treats them as special function characters.

I tried that, and it doesn't seem to work.

If I put "BIN[*]" in the criteria, it's changed to:

Like "BIN[*]"

 

[Alansidman]

Did you try ="BIN[*]"

 

[Alansidman]

Here's MS KB on the subject

http://support.microsoft.com/kb/209536

 

[vbaInet]

I think the OP means he wants to find any word beginning with BIN?

If this is the case then:

LIKE "BIN*"

 

[Alansidman]

VBAInet;
Intersting how two people can read the same thing and interpret it differently. Of course he wanted anything that began with BIN. I'm sitting here chuckling to myself wondering how I saw something different.

 

[vbaInet]

Hi Alansidman,

I had to read it a few times before coming to that conclusion. To be honest I'm not entirely sure if that's what odin is after because the OP wasn't properly worded. So you may even be right afterall