Add regular expression support
Searching using regular expressions seems to be a big oversight on this product. Would help me find embedded expressions that could match a great deal just using wild cards. Something like 'mydatabase.(dbo|[dbo]).\w+\s+myalias'
With wild cards this comes back with lots of matches but very few of what I really wanted...
RegEx is supported in all developments systems. Standard in .net, Java, python, Perl.
There are statements like in the remarks below, also
insert [into] tablename where tablename can be with or without brackets and up to 4 part names
It is just so much used by developers. I was missing this feature in Apex SQL and now after migration, also in RedGate .
Still I can make scripts, and open this in notepad++ and search with regex..
Could be better
Alexander Pakizh commented
I need to find "update tablename". It may be:
So we need the regular expressions!
Typical searches might be search for revenue fields $Revenue matching the first 2 fields.
AdminAdam (Admin, Redgate) commented
Now that we've added support for more advanced syntax such as Boolean operators and wildcards in v2 (http://documentation.red-gate.com/display/SS2/How+to+search#Howtosearch-AdvancedsearchsyntaxAdvancedsearchsyntax ) it would be good to know a bit more about the kind of searches where regex would be useful - if you can provide any examples or further details, that would be very helpful.
Joe Dawley commented
Regular Expressions would be a huge benefit.
Ludvig Derning commented
I currently keep a checked out copy of the subversion project just to regex search, this feature would be great.
+1. For example I want to check whether there are any procedures with the dreaded "select *" antipattern. Given the * can be anywhere after the select (including the next line) a regx based search would be brilliant
Younes Abesi commented
It would be very beneficial if we could search using regular expressions.