Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-28 : 09:35:05
|
Joakim Fagerström writes "Hi!
Recently I read was searching for a way to compare strings in sql case-sensitive.
I found an article on:
http://www.4guysfromrolla.com/webtech/sqlguru/q022400-1.shtml,
where your SQL guru tried to answer that question.
There is a very simple solution, and yes it's very important to use when you compare for example passwords in an application.
Here is a extract from my sql:
select user_id
from val_user
where
user_email = @Email
and convert(varbinary,user_password) = convert(varbinary,@Password)
Regards
Joakim Fagerström" |
|
|
|
|
|
Solution to Case-sensitive searches in sql