How do I get a RegEx to match "GO", but not if it's in a comment?

[JustinF]

I need to parse a string, which contains SQL commands, for the batch terminator ("GO"). I came up with "\s[Gg][Oo]\s" which seems to work as long as there isn't a "GO" in any comments. I have no idea how to tell RegEx to ignore "GO" if it's either in a line comment (--) or within a block comment (/* */). Any RegEx gurus know how to do this?

 

For example, the following "GO"s should be ignored

select * from Customers

-- go

select * from Customers

/*

go

*/

select * from Customers

 

 

But this should return a match:

select * from Customers

go

select * from Customers

[JustinF]

Ok, if nobody knows how to do this, do you know of a good regex forum or something that would be able to help me?

 

Thanks.

[Derek Stone]

Here's a start.

 

(?<!--.*)go