Thanks all

Very useful as, collectively you gave very good pointers regarding parsename, truncate vs delete and quoted identifiers

I am still wondering what the logic behind the original ']' was

Also, when I look at the resultant statements (using print and count), it returned 0 rows in all cases

Suggesting that the statement did nothing!