Posted By

ginoplusio on 11/18/08


login sql case query ASP uppercase lowercase sensitive collate

Versions (?)

SQL case sensitive match for user and password

 / Published in: SQL


When you make a login remember to use CASE SENSITIVE on password and case insensitive on username

  1. SELECT * FROM users WHERE login='youruser' AND password='YourPassword' COLLATE SQL_Latin1_General_Cp1_CS_AS

Report this snippet  

You need to login to post a comment.