Can SQL Search find quotation marks?
KenMcSwain
Posts: 2 New member
in SQL Search
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?
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?
Tagged:
Answers
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 Jary | Redgate Software
Have you visited our Help Center?
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.
Thanks for your reply on this.
I'm glad this has helped! Thanks also for mentioning that using ?" works better!
Dan Jary | Redgate Software
Have you visited our Help Center?