Thank you! 😀

I changed all the the nvarchar datatype to nvarchar(4000). I ran it again and it works. Thank you! 😀

I checked again and it only returns 500 characters. I increased it to 4000. :unsure:

I'm sorry. I don't understand. The value is correct in the database but it truncates when I run the select statement. What do you mean by changing it via Tools,...