title: How do i match text excluding difference between brackets in SQL server?
body: <p>I've an audit log table that has a series of strings like </p>
  
  <blockquote>
    <p>"Some Text[details]more text"</p>
  </blockquote>
  
  <p>the pattern before and after the [details] indicates what the audit trail entry type is. The text in the bracket indicates what it is for. I want to create a query to only find the audit entries i'm after. I thought to use the following like <em>"Some Text[%]more text"</em> but it does not seem to work</p>
  
  <p>When I run the below query it retrieves the expected results + more</p>
  
  <pre><code>select top 1000 *
  from Table
  where NAME like 'Some Text%'
  </code></pre>
  
  <p>When I try </p>
  
  <pre><code>select top 1000 *
  from Table
  where NAME like 'Some Text[%'
  </code></pre>
  
  <p>Nothing comes back is the </p>