title: SQL Query Help: Transforming Dates In A Non-Trivial Way
body: <p>I have a table with a "Date" column, and I would like to do a query that does the following:</p>
  
  <p>If the date is a <strong>Monday</strong>, <strong>Tuesday</strong>, <strong>Wednesday</strong>, or <strong>Thursday</strong>, the displayed date should be shifted up by 1 day, as in <pre>DATEADD(day, 1, [Date])</pre>  On the other hand, if it is a <strong>Friday</strong>, the displayed date should be incremented by 3 days (i.e. so it becomes the following <em>Monday</em>).</p>
  
  <p>How do I do this in my SELECT statement?  As in,</p>
  
  <pre>SELECT somewayofdoingthis([Date]) FROM myTable</pre>
  
  <p>(This is SQL Server 2000.)</p>