title: NVARCHAR is being cut off in the query results
body: <p>There is a column in the database which is of the following type: 
  Value (nvarchar(150), null)</p>
  
  <p>The data comes from a C#-web application where users paste long pieces of text (they are questions from e-mails). I can only view 150 characters of that piece of text when I query the database, and I can see the whole thing in the web application.</p>
  
  <p>How can I write a query which can get all of it? I've tried casting it as <code>nvarchar(max)</code> but that does not work. I've also checked the limit of showing text in Query options which is set at 256. Any ideas?</p>