Return to Answer

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.

The whole query is

SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition Like '%\[ABD\]%' ESCAPE '\' 

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.

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.

The whole query is

SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition Like '%\[ABD\]%' ESCAPE '\' 

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.

Alternative Method:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%Foo%' AND ROUTINE_TYPE='PROCEDURE' 

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.