"Syntax error or access violation" error with nested square brackets in column alias
Ah ... found the answer.  I was running this in an old version of Query Analyser (and got the error above), but it runs fine in SSMS, so error is (falsely) generated by a parsing error in Query Analyser.