title: SQL - Query to find if a string contains part of the value in Column
body: <p>I am trying to write a Query to find if a string contains part of the value in Column (Not to confuse with the query to find if a column contains part of a string).</p>
  <p>Say for example I have a column in a table with values</p>
  <blockquote>
  <p>ABC,XYZ</p>
  </blockquote>
  <p>If I give search string</p>
  <blockquote>
  <p>ABCDEFG</p>
  </blockquote>
  <p>then I want the row with <strong>ABC</strong> to be displayed.</p>
  <p>If my search string is <strong>XYZDSDS</strong> then the row with value <strong>XYZ</strong> should be displayed</p>