Community

I'm trying to match on a SQL INSERT statement, but only up to the first GO statement. I think I need Negative Lookbehind assist, but I could not make it work.

This will keep finding until the LAST GO statement, but I only want the NEXT GO statement after the INSERT.

insert +into +dbo.account .*GO

maybe ungreediness might help (hard to say without the text you want to match).

Ungreedy version of your regex:
(i.e. add a ? to the quantifiers + or * where you don't want greedy version ...)

That was the trick, Mudguard! Many thanks! You truly Grok in Full!

If you guys had backslashes in your regex (i.e. dbo\.account) then those are killed by the forum software.