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.
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.