title: Contains condition over clob in sybase db
body: <p>Can someone help me with the syntax of CONTAINS in Sybase, I have tried below two, and both didn't work :</p>
  
  <p>Query1:</p>
  
  <pre><code>select * from test where column_1 CONTAINS('Set');
  </code></pre>
  
  <p>Exception: </p>
  
  <pre><code>[Code: 102, SQL State: 37000]  Incorrect syntax near 'CONTAINS'.
  </code></pre>
  
  <p>Query2:</p>
  
  <pre><code>select * from test where CONTAINS(column_1, 'Set');
  </code></pre>
  
  <p>Exception: </p>
  
  <pre><code>[Code: 102, SQL State: 37000]  Incorrect syntax near ')'.
  </code></pre>
  
  <p>Please help</p>