Home >> Dababase Interview Questions >> Sql Server 2005 Query

How to get number of time a character occur in a string

Posted on December 14th , 2009 by Admin

CREATE FUNCTION funCharCount( @InputStr VARCHAR(1000), @SearchChar CHAR(1) )

RETURNS INT

BEGIN

DECLARE @InputLength INT

DECLARE @Index INT

DECLARE @Count INT

SET @Count = 0

SET @Index = 1

SET @InputLength = LEN(@InputStr)

WHILE @Index <= @InputLength

BEGIN

IF SUBSTRING(@InputStr, @Index, 1) = @SearchChar

SET @Count = @Count + 1

SET @Index=@Index+ 1
END

RETURN @Count

END

GO