help!

hi all,
i'm having problem with this stored procedure
this doesn't work!
select count(Email)
from Jobseeker
where Email = @.EMAIL and cast(Password as varbinary) = cast(@.PASSWORD as varbinary)

but this works , why? and this one works even if the passwords are in different cases, how do i fix this??
select count(Email)
from Jobseeker
where Email = @.EMAIL and Password = @.PASSWORD

cheers :)If the sort sequence is case insensitive, then string comparisons will be case insensitive as well.

What are you trying to achieve?