title: SQL : Select a table name containing specific string
body: <p>Suppose I have string to search "Sample String" and I have 100 tables in my database.
  I want to search if any of the table contains this string.
  Eg. If tlbSample contains string "Sample String" then it should show it.</p>
  
  <p>I tried :-</p>
  
  <pre><code>SELECT name
  FROM sys.tables
  WHERE name LIKE '%Sample String%'
  </code></pre>
  
  <p>But no luck.</p>
  
  <p>Please help me.</p>