TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Vikram Agrawal
NA
411
8.6k
Sql query
Aug 12 2014 3:04 PM
hello friends,
If at all i want to compare values from database without ignoring case then how can i do this in Sql Server?
for example :
suppose i have this table
TblLogin
UserName
Password
user1
Vikram
user2
csharpcorner
user3
microsoft
Select UserName From TblLogin Where Password='vikram'
(here i m passing password in small case but in the table that is in title case)
this query will return
user1
as result, which is incorrect according to my requirement.
i want to get UserName only when password is in correct case. i.e.
'Vikram'
can you tell me how to write this type of query?
Reply
Answers (
3
)
date time zones
i need to learn the WCF.give me suggestion.