title: Selecting records containing an emoji or counting emoji in text in SQL Server
body: <p>I have a table in SQL Server 2014 (v12.0.6329.1) with a <code>NVARCHAR</code> column that contains text. It's possible that the column contains emoji characters. How can I select or differentiate records that contain at least one emoji? </p>
  
  <p>Bonus points: how can I COUNT the number of emojis in each text?</p>
  
  <p>Example data: </p>
  
  <p><a href="https://i.stack.imgur.com/dvlRQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dvlRQ.png" alt="enter image description here"></a></p>
  
  <p>Ideally, I'd like to make a field that counts the number of emoji, but I'd settle for just being able to tell if there's an emoji at all.</p>