As indicated by
this article, you can perform a case-sensitive search with any of the following techniques: convert to a binary data type, use COLLATE to specify the case sensitivity, as well as a few other options. For better performance without having to change your table or create a view, I'd perform a case-insensitive search, then filter those results using COLLATE or binary conversion to get rid of invalid results.