Like condition with multiple % in SQL Server

Question

I want to search for the following string in a SP. How should I go about it?

cal.[dbo].[GetNumberOfWorkingDays]

I did not get expected results when I tried

 '%cal.[dbo].[GetNumberOfWorkingDays]%'.

Does it work? : '%cal%GetNumberOfWorkingDays%'

[ ] are special characters in LIKE command. See http://stackoverflow.com/questions/3661125/sql-server-like-containing-bracket-characters — etsa, Mar 16 '17 at 15:10

score 1 · Answer 1 · answered Mar 16 '17 at 15:08

1

Square bracket is reserved character in SQL Server like operator syntax, so you have to escape it:

like '%cal.\[dbo].\[GetNumberOfWorkingDays]%' escape '\'

See MSDN for details.

answered Mar 16 '17 at 15:08

Andrey Korneyev

score 1 · Answer 2 · answered Mar 16 '17 at 15:12

Another option would be to use CHARINDEX instead of LIKE. Since I am guessing this is in a where clause it would be something like this.

WHERE CHARINDEX('cal.[dbo].[GetNumberOfWorkingDays]', YourColumn, 0) > 0

2 Answers2