Do you want the bad news? Sorry, but SQL does not behave the same as C, C++ and C#. In those, AND clauses are always executed left - to right, and any false result will abort the operation (called "evaluation short-circuiting"). SQL does not do that. What it does do is more complex. There is a description here:
How SQL Server short circuits WHERE condition evaluation[
^]
Gets my five for a very good question, though!