title: SQL Server Compact Edition 3.5 Missing operand after 'COLLATE' operator
body: <p>I am trying to use collate in a SQL query, ADO.NET on SQL Server Compact Edition 3.5.</p>
  
  <p>Here is how I tried but I always get this error: </p>
  
  <blockquote>
    <p>System.Data.SyntaxErrorException: Syntax error: Missing operand after
    'COLLATE' operator.</p>
  </blockquote>
  
  <p>Here is my query:</p>
  
  <pre><code>select n.Translation
  from Nouns as n
  where n.Translation like '%something%' COLLATE Arabic_CI_AS
  </code></pre>