Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2013-03-05 : 10:21:37
|
Hello All,I have to give [dbo]. string in my LIKE clause.Here is the codeCASE WHEN Wait_Query LIKE '%[dbo].%' SQL is treating [dbo]. as dbo. It is ignoring square brackets. Can you please tell me how to correct it?Thanks,-S |
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2013-03-05 : 10:30:24
|
You need to escape the bracketsCASE WHEN Wait_Query LIKE '%[[dbo]].%' JimEveryday I learn something that somebody else already knew |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|