3
Reply

Interested select query in sql server 2005

kishor choure

kishor choure

Aug 9 2012 1:16 PM
1.1k
I create Logintbl in sql server 2005 . All records inside logintbl are in small letter. When I select record from logintbl  by writing following query

select l_name  from logintbl where l_pass='ABC'

then I get the login name . Same result is displayed when I write the query by following way

select l_name  from logintbl where l_pass='abc' 

I required that records must be find only by small letters not by capital letters in sql server 2005 . Please help me in this regard.


Answers (3)