Case sensitive query for MS Access

[manoj22_srivastava]

Hi All,

I am looking for case sensitive query for MS Access. For whole string, I can use StrComp(). But, I am looking for "Startswith" and "Any part of the field means Contains". It must be case sensitive. I know in SQL but I don't any function for Access. Please share your knowledge if any buddy knows about it.

Thanks & Regards,
Manoj Srivastava

 

[Dennisk]

You could pass the string to a function, and test the ascii value of the first character.

'A' has an ascii value of 65 and 'a' has a value of 97