title: SQL query for a carriage return and Line Feed SQL 2008
body: <p>SQL query is only bringing back 1 Row #1</p>
  
  <pre><code>select  * from email_table  
  where emailAddress like '%'+char(13)+'%'  
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/ZSqMZ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZSqMZ.jpg" alt="enter image description here"></a></p>
  
  <p>Need to bring back first two rowsing with the carriage return in SQL 2008.</p>