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.
3 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Aug 13, 2012, 2:03 AM
you also use collation type with your select query.
try following queries... both have different result.
select l_name from logintbl where l_pass collate Latin1_General_CS_AS ='ABC'
select l_name from logintbl where l_pass collate Latin1_General_CS_AS ='abc'
hope this will help you.
Akkiraju IvaturiPosted Aug 12, 2012, 10:46 PM
VulpesPosted Aug 9, 2012, 1:50 PM
This thread shows how you can do this:
http://stackoverflow.com/questions/137452/how-do-i-change-sql-server-2005-to-be-case-sensitive