Below is my code to verify user. Can anyone suggest me how can i do username and password case sensitive check (SQL SERVER 2000), which the below code lacks.
CREATE PROCEDURE sp_VerifyUser
@uid varchar(20) out
if exists(select * from users where uname=@uname and pwd=@pwd)
select @uid=cast(uid as varchar) from users where uname=@uname and pwd=@pwd