How count occurences of a character in SQL
If you're stuck in a pure SQL environment, you may have found yourself needing to count instances of a character in a text value, then noting there isn't a dedicated function for it. Fear not, there is an easy solution