T-SQL Syntax: The LIKE Operator with Bracket Wildcard Operators ([]); Using Wildcard Characters as Literals

To search for text like '[foo]' and '[bar]' where the brackets are seen as literals we can use the LIKE operator in the WHERE predicate:

...
WHERE [ColumName] LIKE '[[]%]'

This is covered in detail under "Using Wildcard Characters as Literals" in the SQL Books Online documentation here:

http://msdn.microsoft.com/library/default.asp
    ?url=/library/en-us/tsqlref/ts_la-lz_115x.asp

mod date: 2004-04-29T19:05:03.000Z