To get an implementation of the number of occurrences of a string in a long string in SQL

The following is a detailed analysis of the implementation of the number of occurrences of a string in the SQL to obtain a long string, the need for friends can refer to the following

To get an implementation of the number of occurrences of a string in a long string in SQL

For example, there is a string:

x-bgs-2010-09-15-001

I want to know the number of '-' occurrences, which can be implemented in the following ways, without the need for complex character analysis.

DECLARE @a varchar (100)
Set @a= ' x-bgs-2010-09-15-001 '
Select Len (replace (@a, '-', '---'))-len (@a)

The popular point is that if you want to determine how many letters C exist in field B in Table A, you can write

Select Len (b, ' C ', '---')-len (b) from a, of course this function Len may be different from different databases