如何在WHERE子句(我正在使用SQL Server)中进行区分大小写的搜索?

I want to do a case sensitive search in my SQL query. But by default, SQL Server does not consider the case of the strings.I want to do a case sensitive search in my SQL