If Sql is not case sensitive so how can i get desired result

Question

Hello,

I want to know if SQL is not case sensitive then how can i get particular data.
such as:-


In "EmployeeDetail"  table there a  "employee1"  whose password is "NeWdElHi"


and other  "employee2"  whose password is "newdelhi"  and 


if i want data according to  "Password"  field and want result of "employee1" 


so how can i get desired result?


Because if we write query that "select EmpName from EmployeeDetail where password='NeWdElHi' "
i get both values.




Thanks
Prashant Singh