Count Particular Word In String in Sql Server 2000

[kushal49]

Hi,

I need to count a particular word in a string in sql server 2000.
Anybody please help me out in this...

[r035198x]

Hi,

I need to count a particular word in a string in sql server 2000.
Anybody please help me out in this...

Do you mean count the frequency of a particular word in a string?
What does sql server have to do with it?

[Sameerlucky]

Hi,

Refer below example..

while @idx <= len (@sourceStr)
begin
set @currOccurence = CharIndex (@subStr,@sourceStr,@idx)
if (@currOccurence > 0)
begin
set @res = @res + 1
set @idx = @currOccurence
end
else
set @idx = len(@sourceStr)
set @idx = @idx + 1
end
return @res
end

Cheers,
Sameer

[kushal49]

Thanks Sameer!!!
Your code solved my problem...