It's smart enough. You can test this by displaying the execution plan, then moving a couple of AND statements around in your WHERE clause and seeing if anything changes.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills