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.
More Related Contents:
- Insert results of a stored procedure into a temporary table
- How to SELECT FROM stored procedure
- Function vs. Stored Procedure in SQL Server
- SQL Server Insert if not exists
- Stored procedure or function expects parameter which is not supplied
- What is a stored procedure?
- How to assign an exec result to a sql variable?
- SQL Call Stored Procedure for each Row without using a cursor
- How do I execute a stored procedure once for each row returned by query?
- Execute Stored Procedure from a Function
- SQL: Select dynamic column name based on variable
- SQL : in clause in stored procedure:how to pass values
- How to return the output of stored procedure into a variable in sql server
- SQL Server silently truncates varchar’s in stored procedures
- Split values over multiple rows [duplicate]
- How do I pass a list as a parameter in a stored procedure?
- Must declare the scalar variable
- Why execute stored procedures is faster than SQL query from a script?
- Stored procedure that exports data into csv files only exports to one file
- Custom Date/Time formatting in SQL Server
- Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’
- Insert Update stored proc on SQL Server
- SQL Server: should I use information_schema tables over sys tables?
- Inserting rows into a table with one IDENTITY column only [duplicate]
- UNION the results of multiple stored procedures
- Eliminate and reduce overlapping date ranges
- Functions vs Stored Procedures
- How to execute a stored procedure inside a select query
- Dynamic order direction
- Call stored procedure with table-valued parameter from java