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.
Related Contents:
- Insert results of a stored procedure into a temporary table
- Function vs. Stored Procedure in SQL Server
- SQL Server SELECT into existing table
- How to SELECT FROM stored procedure
- SQL Server Insert if not exists
- How to check if a stored procedure exists before creating it
- What is a stored procedure?
- How do I execute a stored procedure once for each row returned by query?
- SQL Call Stored Procedure for each Row without using a cursor
- How can I check if a View exists in a Database?
- How to assign an exec result to a sql variable?
- SQL function as default parameter value?
- SQL Server: Invalid Column Name
- Insert Update stored proc on SQL Server
- How to generate a new Guid in stored procedure?
- Must declare the scalar variable
- Functions vs Stored Procedures
- Could not find stored procedure ‘dbo.aspnet_CheckSchemaVersion’
- How to compare values which may both be null in T-SQL
- Inserting rows into a table with one IDENTITY column only [duplicate]
- How to return the output of stored procedure into a variable in sql server
- SQL Server IF EXISTS THEN 1 ELSE 2
- SQL Server silently truncates varchar’s in stored procedures
- How do I pass a list as a parameter in a stored procedure?
- Get MAX value of a BIT column
- How to execute a stored procedure inside a select query
- SQL Server IF NOT EXISTS Usage?
- Composite Primary Key On Table Variable In Stored Procedure
- SQL Server – How to lock a table until a stored procedure finishes
- Execute Stored Procedure from a Function
- SQL server stored procedure return a table
- UNION the results of multiple stored procedures
- How does SQL Server treat statements inside stored procedures with respect to transactions?
- Creating a stored procedure if it does not already exist
- Executing a stored procedure inside BEGIN/END TRANSACTION
- SQL Server: should I use information_schema tables over sys tables?
- Executing a stored procedure within a stored procedure
- Insert default value when parameter is null
- Error SQL70001: This statement is not recognized in this context
- SQL-Server Performance: What is faster, a stored procedure or a view?
- Add an incremental number in a field in INSERT INTO SELECT query in SQL Server
- Calling stored procedure from another stored procedure SQL Server
- Stored procedure or function expects parameter which is not supplied
- How to get stored procedure parameters details?
- error, string or binary data would be truncated when trying to insert
- How do I set a column value to NULL in SQL Server Management Studio?
- IDENTITY_INSERT is set to OFF – How to turn it ON?
- How to get current instance name from T-SQL
- Why doesn’t SQL Server support unsigned datatype?
- what is numeric(18, 0) in sql server 2008 r2