Pattern Matching in the LIKE operator

% - Any string of zero or more characters.

_ - Any single character.

[ ] - Any single character within the specified range ([a-f]) or set ([abcdef]).

[^] - Any single character not within the specified range ([^a-f]) or set ([^abcdef]).

[[] - specific speicial character - in this case '['.

http://msdn.microsoft.com/en-us/library/aa933232(v=sql.80).aspx