>It splits the alterScope string into separate, presumably SQL command, lines using the 4 strings in new string[] as 'delimiters' For example, given:
string alterScopeSql = "SELECT * FROM ORDERS GO SELECT * FROM Customers GO";
> string[] commands = alterScopeSql.Split(new string[] {"GO\r\n","GO ","GO\t","GO"}, StringSplitOptions.RemoveEmptyEntries);
then after running 'commands' would be:
>[0] "SELECT * FROM ORDERS"
>[1] "SELECT * FROM CUSTOMERS"
Thanks Viv, that makes it crystal clear.
I passed through Leominster for one night back in August and thought of you but my wife and Aunt would have killed me for leaving them and meeting you at a pub somewhere :)