Vinod's approach is the correct one, though I didn't check to make sure the details are 100% right.
If you feel bad about depending on left-right evaluation you can always use parenthesis. Since (a left b) left c isn't equivalent to a left (b left c) in the general case, you don't really have to worry about any SQL92-compliant RDBMS changing the evaluation order, though.
