Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Interested select query in sql server 2005
kishor choure
Aug 9 2012 1:16 PM
1.1k
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Regarding sql server 2005
how to wite a query to insert only 10 records into database by using C#.net