From: erik.lennart.jonsson@gmail.com   
      
   On 11/24/2014 11:37 PM, Erland Sommarskog wrote:   
   > Lennart Jonsson (erik.lennart.jonsson@gmail.com) writes:   
   >> I think (don't have time to look it up now) the SQL-standard says that   
   >> the result of the CASE statement is the first condition that evaluates   
   >> to true. From your answer I get the impression that this is not true for   
   >> SQL-server, correct?   
   >   
   > That is indeed true. The issue is that the expression on the left-hand side   
   > is reevaluated for every branch in the CASE.   
   >   
      
   I see, thanks   
      
      
   /Lennart   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)