hi
i use statement as follows for checking user/pass of users:
it considers both username and password case-sensetive, how can i change the statement the way that only password considered case-sensetive.
i think BINARY operand affect the entire where statement, am i right?

The binary operator converts a string to an array of bytes and compares the results byte by byte. This only applies to the variable preceding the BINARY reserved word.

I am not sure why you would want to convert it to a binary and not compare it at a string level?