Thanks, Jeffrey!

Solved problem. I was being stupid.

Was 'Opening' table in Mgmt Studio, and running script in window.

When I check syntax/run in query new query window seperate from table, with...

nothing else on line with GO, will try lower case.

Thanks.

Can't put 'exact' code I am trying to run, due to company security, but code example above is exact, other than table and column names.

The parans are there because SQL...

Popup MessageBox said 'syntax error near GO' for each of the GO statements.

I am not at office now, will post EXACT error in a few hours when I get in.

Thanks...

Thanks much. For both responses.

The 'select' instead just 'values' part is what I needed.

Will remember to post SQL I am trying to use in future as well.