title: Truncate nvarchar(max) to nvarchar(n) with ellipses
body: <p>What's the quickest way to convert nvarchar(max) to nvarchar(n) and indicate there's more data?</p>
  
  <p>eg: convert the column Address to nvarchar(100) and if Address is larger than 100 characters then replace the last 3 characters with "..."</p>