Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Reply
Regarding sql server 2005
kishor choure
12 years ago
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.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Update Table using Sub Query in SQL Server
Interested select query in sql server 2005