Can SQL Search find quotation marks?

KenMcSwain

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?

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?

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.

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!