How can we help you today? How can we help you today?

SQL Search Wildcards and escaping square brackets

I'm searching for something along the lines of  ['+ @Linkedserver +'].dbo
Escaping square brackets with square brackets doesn't work.  What am I doing wrong?
[[]'*+*[@]*+*'[]].dbo

"UNIX style wildcards" isn't helping me figure it out.  Could someone point me to a cheatsheet?
Edward
0

Comments

2 comments

Sort by
  • Dan B
    Hi undrline,

    The documentation for this can be found on the following page:

    https://documentation.red-gate.com/ss3/how-to-search
    Dan B
    0
  • undrline
    While helpful, it's missing reserved words and characters that would need escaping.

    And, it looks like my issue is related to

    Square Brackets

    Square brackets around identifiers are filtered out of the index we create to provide fast searches, so you can't match on them even if you are using wildcard matching and escape them.

    But I'm not understanding what that means.  Does it mean to just leave them out of the search string, and it will assume that I don't care if there are square brackets or not?  What if the square brackets are the only thing that distinguishes my search constants?

    undrline
    0

Add comment

Please sign in to leave a comment.