Escape the square brackets: ... WHERE m.definition Like '%\[ABD\]%' ESCAPE '\' Then the square brackets will be treated as a string literals not as wild cards.