I think you mean Thom A. SSChasing Mays is a title. The name is above the avatar.

It's saying that there is an error near the minus sign. Since there is only one minus sign in the entire script, it's somewhere near here:

SET @SQL = 'UPDATE orders

SET ' + (LEFT(@SQL, LEN(@SQL)-1)) + ';';

Of course, Thom A is using dynamic SQL, so it's also possible that the error is in the generated code, which we can't see. For example, if your column names contain '-' then this will also generate an error, because Thom A's code hasn't properly accounted for column names that include anything other than A-Z, 0-9, and _. When creating your dynamic SQL, you should use the Quotename function to properly quote your column names.

Drew