SQL Server LIKE containing bracket characters

 ... like '[[]%'

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

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

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