title: TSQL Case Statement
body: <p>I have a table that look like this:</p>
  
  <p><a href="https://i.stack.imgur.com/fqMhG.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fqMhG.jpg" alt="enter image description here"></a></p>
  
  <p>How do I write a case statement to pull out only the latest rate, which in this case would be Rate14?  Anytime the rate is 0.0000, then I would need to fall back to the previous rate. </p>
  
  <p>Any help would be appreciated.</p>