title: How to search multiple strings or chars in a field in sql
body: <p>I am using sql server and i have a table which have two fields </p>
  
  <ol>
  <li>Name</li>
  <li>Description </li>
  </ol>
  
  <p>I want to select all those rows which contains following strings </p>
  
  <p>('$','%' , 'ac cd' , 'hjd oih') </p>
  
  <p>I am using it like this </p>
  
  <pre><code>select Name , description from table_name 
  where Description like any (' %$%',' %[%]%','%ac cd%' , '%hjd oih%')
  </code></pre>
  
  <p>now its giving error when i run this </p>
  
  <pre><code>Incorrect syntax near the keyword 'any'.
  </code></pre>
  
  <p>thanks ,</p>