Well there is no problem executing the query as is as I have posted and @query3 is not missing any apostophies as such as I closed it after = '...

Yeah it does work but I am wondering is for the same query it returns me

188 264 410 379 respectively for @query1,@query2,@query3,@query4.

And it gets executed from my program without any issues with desired output.

Thanks

Well the query is something like this, each one of the variables @query1,@query2...3..4 are declared as varchar(8000), since I am not sure after how many characters it is breaking I...

Yeah Exactly, however my problem is that the variable is not even holding more than 500 characters even when I have defined the variable as varchar(8000). I don't know if...