title: Get Word Count of a Column using SQL
body: <p>I have a table with a column called <code>Description</code>. The column is populated with text data. I want to create a query that returns the amount of words in each description.</p>
  
  <p>My thought was to create a function that takes in a value, and returns the amount of words found in the inputted text.</p>
  
  <pre><code>SELECT dbo.GetWordCount(Description) FROM TABLE
  </code></pre>
  
  <p>For example, if the description is "Hello World! Have a nice day.", the query should return 6.</p>
  
  <p>How can I get the word count of the description column?</p>