title: SQL Not Like Statement
body: <p>How can I select table from sys.tables where table name does not containt special word (which pass in parameters).</p>
  
  <p>I want to select all tables where its contains word 'customer' but not those who ends with 'old'
  in name.    </p>
  
  <p><strong>TableName In DB</strong></p>
  
  <p>customer1<br>
  customer2<br>
  customer3<br>
  customerold1<br>
  customerold2  </p>
  
  <p><strong>Output Wanted</strong></p>
  
  <p>customer1<br>
  customer2<br>
  customer3      </p>