title: WHERE clause on SQL Server "Text" data type
body: <p>Where [CastleType] is set as data type "text" in SQL Server and the query is:</p>
  
  <pre><code>SELECT *
  FROM   [Village]
  WHERE  [CastleType] = 'foo' 
  </code></pre>
  
  <p>I get the error:</p>
  
  <blockquote>
    <p>The data types <strong>TEXT</strong> and <strong>VARCHAR</strong> are incompatible in the equal to operator.</p>
  </blockquote>
  
  <p>Can I not query this data type with a WHERE clause?</p>