How to do case sensitive comparison in SQL SERVER

leo_vinay · January 24th, 2005, 03:30 AM

Hi all,
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.

Code:

CREATE PROCEDURE sp_VerifyUser
@uname varchar(30),
@pwd varchar(30),
@uid varchar(20) out
AS
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
else
    select @uid="notfound"
GO

Thanks

Vinay

Shibu · January 24th, 2005, 04:55 AM

Use the code below

select * from [tbl_name] WHERE CAST(string1 AS VARBINARY(999))=CAST(string2 AS VARBINARY(999))

Shibu Narayanan
Software Associates

Vadivel · January 24th, 2005, 01:46 PM

http://vyaskn.tripod.com/case_sensit...sql_server.htm

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com