title: How to use ! in mentioned query?
body: <p>I have data in below format</p>
  
  <p>('CA-2014-118892', '8/18/2014', 'Tom Prescott', 'Furniture', 'Chairs', 4416.174, -630.882),</p>
  
  <p>('US-2012-163825', '6/16/2012', 'Lena Creighton', 'Office Supplies', 'Binders', 3050.376, 1143.891), </p>
  
  <p>('CA-2012-114811', '11/8/2012', 'Keith Dawkins', 'Technology', 'Machines', 4643.8, 2229.024)</p>
  
  <p>Now when i try to use wildcard [!T]% on third value/column which is name, I was hoping it would give me the other two(Lena and Keith). Instead it is showing me the entry from customer 'Tom'.</p>
  
  <pre><code>CREATE TABLE ORDERDATA
  (
      Ord_ID CHAR(15),
      Ord_date DATE NULL,
      Cust_name VARCHAR(50) NOT NULL,
      Category CHAR(20) NULL,
      Sub_C CHAR(20) Null,
      Sales INT NOT NULL,
      Profit INT NOT NULL
  )
  
  SELECT * FROM ORDERDATA WHERE Cust_name LIKE '[!T]%'
  
  </code></pre>
  
  <p>I dropped the table and re added values just to be sure it was not some run error but this error persists.</p>