title: Enter key issue in SQL
body: <p>I have a column that is defined as a <code>nvarchar(100)</code>. </p>
  
  <p>Sometimes office users press enter key wrongly and it causes problems in some applications. When I check the value it seems like <strong>double space character</strong> in SQL Server. Now my mission is finding the records that has this situation. I tried the code below to find the problematic records:</p>
  
  <pre><code>DECLARE @NewLineChar AS CHAR(2) = CHAR(10) + CHAR(13);
  
  SELECT * 
  FROM TBLCASABIT 
  WHERE CARI_ISIM LIKE '%'+CHAR(10) + CHAR(13)+'%'
  </code></pre>
  
  <p>but it doesn't return the records I need. </p>
  
  <p>If I use <strong>double space character</strong> I can see the test record I put and some other records has double space character. So I can't be sure if other records have the same situation or not. </p>
  
  <p>How can I handle this situation? Any help will be appreciated.</p>