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

How to include brackets

Hello.  I want to search for specifically [dbo] including the brackets and I don't want to return dbo if there are no brackets.  I tried [[,]] and ?[, ?] and a few others.  How do I do this?

Thank you
Matthew Wells
0

Comments

2 comments

Sort by
  • lgivens
    Hi Matthew,
     
    Thank you for your inquiry. Unfortunately I don't think there is a way to do what you are wanting. In reviewing the documentation on SQL Search, it specifically mentions square brackets:
     

    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.

     
    Basically that means that [dbo] and dbo look the same to SQL Search. If this is a feature you feel needs to be added, please visit our UserVoice portal at https://redgate.uservoice.com/forums/101149-sql-search, and make the suggestion.
     
    Let me know if this helps.

    Thank you,
    Lee Givens
    Product Support Engineer
    lgivens
    0
  • josh

    good info

    josh
    1

Add comment

Please sign in to leave a comment.