Escaping square brackets when using LIKE operator in sql

Asked May 23 '17 at 08:10

Active May 23 '17 at 10:39

Viewed 54 times

I am trying to search for this string [Name].[Names - Software].[Names Delivery]

II have the following but its not finding anything:

DECLARE @string AS VARCHAR(50) = '%\[Name].[Names - Software].[Names Delivery]%'

SELECT  Name
FROM    sys.procedures
WHERE   OBJECT_DEFINITION(OBJECT_ID) LIKE @string ESCAPE '\'

How do I change @string so it will find all instances of the string?

edited May 23 '17 at 10:39

a_horse_with_no_name

497,550
91
775
843

asked May 23 '17 at 08:10

whytheq

32,991
61
166
261

3

Tag the dbms you're using. That code is product specific. – jarlh May 23 '17 at 08:13
1

Also, sample data as DDL+DML and desired results would help. – Zohar Peled May 23 '17 at 08:16
@jarlh good point - added. – whytheq May 23 '17 at 08:20
[Read this](https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql), especially about *escaping*... – Shnugo May 23 '17 at 08:47
1

Btw: It took about three seconds to find the existing question... Please do some research first... – Shnugo May 23 '17 at 08:49

Escaping square brackets when using LIKE operator in sql

0 Answers0