title: IF Condition in an SQL query
body: <p>I'm a newbie to SQL Server. Please help me to write the following Logic in a query.</p>
  
  <pre><code>If getnow() &gt; today 4 PM
  Then
      SELECT *
      FROM table
      WHERE MailDate is Tomorrow
  Else
      SELECT *
      FROM table
      WHERE MailDate is Today
  </code></pre>