title: sql server: need to escape [?
body: <p>I need to escape [ in an sql query for SQL Server</p>
  
  <pre><code>select * from sometable where name like '[something]';
  </code></pre>
  
  <p>I actually am looking for a [ before something and I don't want it to act like a wildcard.  I tried :</p>
  
  <pre><code>select * from sometable where name like ''[something]';
  </code></pre>
  
  <p>But get error message from this:</p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'something'.
    Msg 105, Level 15, State 1, Line 1 Unclosed quotation mark after the
    character string ';</p>
  </blockquote>