title: Sql pull prior day except on Mondays pull Friday thru Sunday
body: <p>Here is my code for MySql,</p>
  
  <pre><code>BETWEEN DATE_SUB(CURDATE(), INTERVAL (IF(DAYNAME(CURDATE()) = 'Monday',3,1)) DAY) AND
          DATE_SUB(CURDATE(), INTERVAL (IF(DAYNAME(CURDATE()) = 'Monday',1,1)) DAY)
  </code></pre>
  
  <p>I know how to pull the prior day without time in Sql Server 2008 but I have not been able to get anything to work converting this line of code over from MySql to Sql.</p>