title: How do we match the special character(s) in sybase using like?
body: <p>How do we match the special character(s) in sybase using like?</p>
  
  <p>I'm using the like condition as a filter to any characters user inputted. Currently using the sybase database. I was able to retrieved some results by inputting some words, But if the user input some special characters like square bracket. It doesn't return any result but when I check the database I can see the square bracket or any special characters in the database.</p>
  
  <pre><code>Sample Data: column searchField : [IAN]Stackoverflow
  Declare @value varchar(50)  
  SET @value = '[IAN]Stackoverflow'  
  
  SELECT * FROM Table1 WHERE searchField LIKE '%@value%
  </code></pre>