when using sql in access database, for string criteria, is it case sensitive? e.g. where PersonName like "LINDA", is equal to: where PersonName like "linda"?

CodePudding user response：

You could use the StrComp function in an Access query

SELECT tblSource.ID, tblSource.Test
FROM tblSource
WHERE (((StrComp([tblSource].[Test],"LINDA",0))=0));

This will return only the rows with LINDA, it will not return Linda or LInda etc.