LIKE Pattern Matching with Brackets

Madhivanan shows how you can find special characters like left brackets when performing pattern matching with LIKE:

In SQL Server you can use LIKE operator to search for particular string in a column value. However it is important to note that when you search for a string which is within square braces, you need to escape the opening square brace.

Click through for an example.