title: Is there a opposite function to ISNULL in sql server? To do Is not null?
body: <p>I have this code in my select statement</p>
  
  <pre><code>ISNULL(a.PolicySignedDateTime,aq.Amount) AS 'Signed Premium',
  </code></pre>
  
  <p>But I want to see if "a.PolicySignedDateTime" is not null. 
  Is there a easy function to do this which does not involve using a "if" statement?</p>
  
  <p>Cheers guys</p>