hi,

 i want to parse a file that contains SQL queries which can be executed within SQL Server Query Analyzer. The format of the file is

 SQL Statement 1

GO

SQL Statement 2

GO

SQL Statement 3

GO

etc

 What i want to do is extract each SQL statement, eg (SQL Statement 1, SQL Statement 2 etc). Each statement maybe multiple lines of valid transact SQL.

 Can somebody help with a regex to do this.

thanks,

rumballs