SQL 字符出现的次数

 

SQL查询字段中某个字符出现的字数，

1：字符长度-替换掉的字符长度=字符出现的次数

SELECT TOP 200 ID ,ShortName, LEN(ShortName)-LEN(REPLACE(ShortName,'.','')) AS appLen FROM BD_Client
WHERE Flag=0 ORDER BY ID DESC