Ask SQLTeam Question
Posted - 07/26/2002 : 09:40:42
| Koen writes "Hi,
I think I found a solution to the following problem posted by Eric :
Today's question comes from Eric:
I was just wondering if there is a way to get an exact comparison of two strings. I am specifically concerned with the case of the strings..."
In SQL2000 I created a login stored procedure :
CREATE PROCEDURE Rp_LoginUser
where acLogin=@Login and acPassword=@password collate Latin1_General_CS_AS
By adding the 'collate' option, I made the sort-order of the acPassword column to be case-sensitive !!
This seems to work !"