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?
