Login with a case sensitive password with a Stored Procedure

I have a stored procedure that validates a user login against a username and password field.
How can I ensure case sensitivity in the stored procedure for the password field?Hi

If you cast both the inputted password and the stored password as varbinary, if they are not the same case they will not match.|||OK i tried it but how do I change the the user input from a string a varbinary for the
Stored procedure input parameter ?|||I figured it out.
Thank you, merkin|||If you use MD5 to encrypt the password then it will be case sensitive and won't be crackable if the table becomes visible to a hacker.

Login problem

Hi all,
I wrote an ISAPI (dll) application to work with a database on my SQL2K. When
I use windows NT integrated security (MyDomain\Username), The application
works properly. But when I use a specific username and password (using a sql
buildin login) I get this error message when adding a new record to the
database.
Internal Application Error
Application uses a value of the wrong type for the current operation
I granted the user to have full access to the database.
Any help would be appreciated.
Thank you,
MehrdadHi
Does the user have all appropriate permissions to insert data into table?
"M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
news:%23CCQpjtyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I wrote an ISAPI (dll) application to work with a database on my SQL2K.
When
> I use windows NT integrated security (MyDomain\Username), The application
> works properly. But when I use a specific username and password (using a
sql
> buildin login) I get this error message when adding a new record to the
> database.
> --
> Internal Application Error
> Application uses a value of the wrong type for the current operation
> --
> I granted the user to have full access to the database.
> Any help would be appreciated.
> Thank you,
> Mehrdad
>|||Yes, the user have all the permissions to Insert, Delete, Edit, and Create
the table.
Mehrdad
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O4Zq21tyEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Hi
> Does the user have all appropriate permissions to insert data into table?
>
>
>
> "M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
> news:%23CCQpjtyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> When
application[vbcol=seagreen]
> sql
>|||Hi
Perhaps you try to insert a value that has a different datatype (as error
said). Can you show us the INSERT statement?
"M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
news:uK$TWauyEHA.352@.TK2MSFTNGP14.phx.gbl...
> Yes, the user have all the permissions to Insert, Delete, Edit, and Create
> the table.
> Mehrdad
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O4Zq21tyEHA.3120@.TK2MSFTNGP12.phx.gbl...
table?[vbcol=seagreen]
SQL2K.[vbcol=seagreen]
> application
a[vbcol=seagreen]
the[vbcol=seagreen]
>|||Thank you Uru for your notice to my problem. I asked the administrator to
restart the SQL server. It works now properly.
Thank you,
Mehrdad
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OMn4KduyEHA.2568@.TK2MSFTNGP10.phx.gbl...
> Hi
> Perhaps you try to insert a value that has a different datatype (as error
> said). Can you show us the INSERT statement?
>
>
>
> "M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
> news:uK$TWauyEHA.352@.TK2MSFTNGP14.phx.gbl...
Create[vbcol=seagreen]
> table?
> SQL2K.
(using[vbcol=seagreen]
> a
> the
>