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

Can SQL Search find quotation marks?

Hi All
I want to find all uses of double quotes in a body of SQL Server code.
I put " in the seach box, but nothing.
Ditto for ["].
''' finds that string, literally.
I've run out of ideas.
Is there a way to do what I want?

Answers

  • Options
    Hi @KenMcSwain

    Thanks for reaching out to us regarding this.
    Search criteria requires 2 or more characters to start returning results, so searching for just one double quote won't return any results.

    If you check 'Use wildcards' (located to the right of the search box) and search for either *" or "*, do you get any result returned then?
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Options
    Hi @Dan_J
    Thanks.
    That works wll enough for what i need to do.
    Actually ?" works better, because *" highlights all the text up to the quote mark, but ?" just highlights the quote mark and the one character before it, which is much clearer.
  • Options
    Hi there @KenMcSwain

    Thanks for your reply on this. 

    I'm glad this has helped! Thanks also for mentioning that using ?" works better! 
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.