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.
For further actions, you may consider blocking this person and/or reporting abuse
Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.
Turing -
Ahmad Tibibi -
Rivka -
Laetitia Perraut -
Top comments (0)