title: T-SQL - text field to nvarchar
body: <p>I have a 'text' type in a SQL table (BigNote), and a new nvarchar(2000) field (LittleNote).</p>
  
  <p>I need to save the first 2000 characters from the @BigNote into the LittleNote field within a stored procedure.  Can someone share some thoughts?</p>
  
  <p>Do I need to check for:
   - nulls?
   - the BigNote length and only grab the exact amount?</p>
  
  <p>It is working by just assigning LittleNote = @BigNote, but I want to avoid problems when the text is too big etc...</p>
  
  <p>Once we release an update to the application, we will handle this more elegantly, but in the meantime we need to get a non-Text field with this data in the database.</p>