返回字符串中某字符出现的次数

-- ============================================= -- 返回字符串中某字符出现的次数 -- ============================================= CREATE FUNCTION GetCharCount ( @cValue NVARCHAR(1000), @cChar NCHAR(1) ) RETURNS INT AS BEGIN DECLARE @i INT, @iCount INT SET @i =1 SET @iCount=0 WHILE(@i<=LEN(@cValue)) BEGIN IF(SUBSTRING(@cValue,@i,1)=@cChar) SET @iCount = @iCount+1 SET @i=@i+1 END RETURN @iCount END GO