SQL Server LIKE containing bracket characters

by 
 ... like '[[]%'

You use [ ] to surround a special character (or range)

See the section “Using Wildcard Characters As Literals” in SQL Server LIKE

Edit, 24 Nov 2011

Note: You don’t need to escape the closing bracket…

More Related Contents:

  1. Select distinct record from table and perform Sum of column (Pallats, Gross) of a duplicate row. And show that duplicate rows once [closed]
  2. How to delete 0 values but not blanks from a column in SQL Server 2008 programming?
  3. Select top 10 records for each category
  4. What this query does to create comma delimited list SQL Server?
  5. SQL Server – Return value after INSERT
  6. Parameterize an SQL IN clause
  7. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  8. When no ‘Order by’ is specified, what order does a query choose for your record set?
  9. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  10. SQL Call Stored Procedure for each Row without using a cursor
  11. How to select the last record of a table in SQL?
  12. What’s the best way to capitalise the first letter of each word in a string in SQL Server
  13. SQL string comparison, greater than and less than operators
  14. Splitting the string in sql server
  15. How do I group on continuous ranges
  16. join comma delimited data column
  17. Group DateTime into 5,15,30 and 60 minute intervals
  18. How to replace (null) values with 0 output in PIVOT
  19. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  20. How can I compare time in SQL Server?
  21. Column name or number of supplied values does not match table definition
  22. SQL Group BY, Top N Items for each Group
  23. SQL – Difference between COALESCE and ISNULL? [duplicate]
  24. T-SQL Skip Take Stored Procedure
  25. Return rows in the exact order they were inserted
  26. Convert date to YYYYMM format
  27. Is there a quick way to check if ANY column is NULL?
  28. Combine Two Tables in Select (SQL Server 2008)
  29. T-SQL Conditional Order By
  30. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?

Leave a Comment