Loading

Regarding sql server 2005

kishor choure

14y1.7k

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.