Compare a string with itself.

[John Sh]

I have a table where some of the entries start with a lower case character.
I need to isolate those entries.
If I run the following query it returns nothing.
If I change "<>" to "=" it returns everything but the required entries.

SELECT Taxon.family, Taxon.genus
FROM Taxon
WHERE (((Taxon.genus)<>LCase([taxon].[genus])));

Why is it so?

 

[CJ_London]

Access is not case sensitive - you need to use the strcomp function

StrComp function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

 

[John Sh]

Access is not case sensitive - you need to use the strcomp function

StrComp function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

I was heading that way, but hadn't quite got there.
Thank you for the heads up.