hi all,

 i am using asp.net 2.0, and both MS SQL 2000 and 2005

 i have a table -login like below

UID             UserName             Password

  1                   test                    test

i want to login to a web application using this username and password

but, what i want is, it should be case sensitive

a user shall be able to enter in to the application only if he enters username -test and password -test

he shall not enter for other combinations like TesT, Test, tesT etc...

how shall i do that?

thanks in advance

plz don't confuse when i said 'both MS SQL Server 2000 and 2005'

for some application, i use MS SQL Server 2000

and for some other application, i use MS SQL Server 2005

Hi

The reason why the username is non-case-senitive is that in the stored procedure [dbo].[aspnet_Membership_CreateUser],  UserName is converted into all lowercase before inserting into the DB

Hope it helps.

How are checking for username, password in your webapplication? Are you using membership api?

 Hi,

You have to use "CAST" Function in SQL statement, as follows,

SELECT *
    FROM logintable
    WHERE CAST(LoginName  AS Varbinary(255))=  CAST('test'   AS Varbinary(255)) AND [Password] = @Password  

Here the password is md5 encrypted....

hope this will help you..

regards

prasanth 

hi prasanth,

Thank you very  much