title: count # of times a text appears in a str
body: <p>I am trying to search this <code>string(TenderString1)</code> for <code>SPT</code>. This just outputs the number of characters - so if there were 1 <code>SPT</code> in this string it would return 3 (number of characters).  So I am attempting to divide the result by the length of <code>SPT</code> (3) to get the number of occurrences of <code>SPT</code> in the string but it is not returning the correct number<br />
  <code>(LEN(TenderString1) - LEN(REPLACE(TenderString1, 'SPT', '')) / len('SPT'))</code>Test</p>
  <p>TenderString1 Column:</p>
  <pre><code>UAD,MTY,CL,CLTG,OFD,OFD,SPT,SL
  </code></pre>
  <p>Answer should be: 1</p>