While implementing a feature of a GUI Editor, we came across a requirement to count the occurrences of characters in a string, stored in our SQL Server Database.
I was suggested a simple and efficient script that I am sharing with all of you for your use.
DECLARE @longWord varchar(28)='AntiDisEstablishmentArianism'
SELECT CountCharacters =
- DATALENGTH (REPLACE(REPLACE(LOWER(@longWord),'a',''),'i',''))
As simple as it gets without using the SUBSTRING, PATINDEX or GROUP BY functions!