What are the challenges you face when working across database platforms? Take the survey
Options

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
Tagged:

Answers

  • Options
    lgivenslgivens Posts: 5 New member
    edited December 20, 2023 9:55PM
    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
Sign In or Register to comment.