Mark,

The statement is going against SQL Server 6.5.

The wierd part is that the statement work just fine in the command window, it's when I want to populate a string variable for a SQLEXEC() command that I get the syntax error in the debugger.