The COUNT function returns the number of times that one string occurs in another.
Both expression1 and expression2 may evaluate to any data type but logically they will evaluate to character strings.
The count is made on overlapping occurrences as a pattern match from each character in expression1. This means that the string jjj occurs 3 times in the string jjjjj.
Also see DCOUNT.