Oh God!! Case sensitivity and Poor M$ Access

Written by hasin

Last night I was searching how I can run a case sensitive query in Microsoft Access. After searching for a while what I found in microsoft knowledge base is that there is no ANSI SQL compliant way to check case sensitivity in Access. All you have to do is compare it with StrComp() function. Poor Access!!

SELECT case_sensitive_data FROM table_name WHERE StrComp(case_sensitive_data, “some_data”,0)=0

Oh Selucas, what a world we live in!!!