Prashant Singh

Prashant Singh

  • 1.8k
  • 40
  • 59.4k

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

Sep 13 2012 7:27 AM

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.

Prashant Singh

Answers (4)