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

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?
KenMcSwain
0

Comments

3 comments

Sort by
  • Dan_J
    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?
    Dan_J
    0
  • KenMcSwain
    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.
    KenMcSwain
    0
  • Dan_J
    Hi there @KenMcSwain

    Thanks for your reply on this. 

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

Add comment

Please sign in to leave a comment.