title: SQL Datetime Not Equal To Is Not Working
body: <p>I have a database consisting of a Customer, Product, and Transaction table.</p>
  
  <p>I'm trying to write an SQL statement to list all customers' names and SSN's for those customers who have made no transaction in the year 2000.</p>
  
  <p>The TransactionDate column in the Transaction table is a Date/Time data type (e.g. 2000-12-18 00:00:00).</p>
  
  <p>This is the SQL code I've written:</p>
  
  <pre><code>SELECT DISTINCT CustomerName, Customer.CustomerSSN 
  FROM Customer, Transaction
  WHERE Customer.CustomerSSN=Transaction.CustomerSSN
  AND YEAR(TransactionDate)&lt;&gt;2000;
  </code></pre>
  
  <p>The not equal to symbol (&lt;>) seems to not be working for some reason. When I change it to an equal sign, it does return the correct result...</p>
  
  <p>Any advice is appreciated.</p>