function to get number of time a character occur string

HomePage Jobs WalkIn Articles Group Chat Contact Us Feedback Sitemap

	To improves our performance please Like Share Subscribe(Will boost us)
	Follow

function to get number of time a character occur string
Question Posted on 26 Jun 2011Home >> DataBase >> SQL Query >> function to get number of time a character occur string

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

	0
	0


	.

	Most Visited Questions:-
	Deep Learning Questions Answers Below are the different Deep Leaning Questions and answer a More...
	Continuous Integration Questions Answers Below are the 20 odd questions for CI or Continuous Integra More...
	Derived relationships in Association Rule Mining are represented in the form of __________. Derived relationships in Association Rule Mining are repres More...
	What is Gulpjs and some multiple choice questions on Gulp Gulpjs is an open source whihc helps in building Javascript More...
	Microservices Architecture Questions Answers Below are the different questions on Microservices Architec More...

To improves our performance please Like Share Subscribe(Will boost us)