Selection Criteria: Problems with Or

[Sagebrook]

I need to select records where a field equals "091s" or "091S".


Here is what I've tried:

If I use "091s" Or "091S", I only get records with "091s".
If I use "091S" Or "091s", I only get records with "091S".

"091S" Or "081S" gets me both requested sets, so I know the Or can work.

I thought about using Like "091*", but that also returns "091c" which I do
not want...

 

[KARL DEWEY]

Did you try "091S" alone? It should return both upper and lower case.

 

[Sylvain Lafontaine]

You should show us the full query that you're using here.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Sagebrook]

"091S"
didn't work

"091s"
also didn't work

Like "091s"
works and so does
Like "091S"

I still don't understand why the Or statement does not work in this case.

 

[KARL DEWEY]

Like Sylvain said you need to post the SQL of your query. Open in design
view, click VIEW - SQL View, highlight all, copy, and paste in a post.