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

I need to find "update tablename". It may be:
update tablename
update tablename
update dbo.tablename
update dbo.[tablename]
etc.

So we need the regular expressions!

Typical searches might be search for revenue fields $Revenue matching the first 2 fields.

GrossRevenue
NetRevenue
NetRevenueMargin
GrossRevenueMargin

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.

Thanks, Adam

Regular Expressions would be a huge benefit.

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

It would be very beneficial if we could search using regular expressions.