title: sql query to find a column value with specific text available
body: <p>Is their any other way to find a column values with the specified text available in it.</p>
  
  <p>i know their is one way like,</p>
  
  <pre><code>SELECT COLUMN_NAME FROM TABLE_NAME
  WHERE COLUMN_NAME LIKE '%sample_text%'
  </code></pre>
  
  <p>and i tried </p>
  
  <pre><code>SELECT COLUMN_NAME FROM TABLE_NAME
  WHERE CONTAINS(COLUMN_NAME,'sample_text')
  </code></pre>
  
  <p>also but it requires table to be full-text indexed</p>