Thanks for looking, I appreciate it, however I have tried removing the 'N' but it's still happening - the code for building the string now looks like this.

SET @sqlstring =...

I have checked the data source (tbl_11689_ShareTransactions) and there are no NVARCHAR fields... also, the length of @sqlstring is 4000. The code is below, I have also scripted the...

I've checked the data source, which is a physical table (tbl_11689_ShareTransactions) and there are no nvarchar fields there. Also the length of @sqlstring is 4000... I have...

Thanks guys. That would explain why it won't execute, but why is @sqlstring not being populated up to 8000 to start with, as it is defined as a varchar...

exec (@sqlstring)

Thanks JacekO for replying. However there are no nvarchar fields in the query.

However if I do SELECT @sqlstring = @sqlstring + @sqlstring, the length of @sqlstring increases to 8000.

It...