title: SQL Server, C#, ntext, nvarchar, how to use not equal to
body: <p>To begin with I want to say that I'm aware that this could be solved by column datatype changes in the database, but that is not an option, since the database is from an older system which is not under my control.</p>
  
  <p>I want to query the database and find something like: </p>
  
  <pre><code>where Field1&lt;&gt;@Field1Value Or Field2&lt;&gt;@Field2Value
  </code></pre>
  
  <p>Where <code>Field1</code> and <code>Field2</code> are <code>nvarchar</code> and <code>ntext</code> columns.</p>
  
  <p>Is there a way to do this with SQL?</p>
  
  <p>Thank you.</p>