Count a particular character in string.

[tmunson99]

Is there a SQL command that will count the number of times a particular character occurs in a string? For example, I have an Org string - 123.ABC.abc.def.ghi.jkl.mno or 123.ABC.abc.def. I have a stored procedure that parses each tuple. Without getting into the complexity of the stored procedure, is there a SQL query I can run against OrgId that will count the number of periods [.]?

So 123.ABC.abc.def.ghi.jkl.mno, will return 6
and 123.ABC.abc.def returns 3

 

[SQLDenis]

len(Column) - len(replace(Column,'.',''))

example

declare @v varchar(500)
select @v ='123.ABC.abc.def.ghi.jkl.mno'

select len(@v) - len(replace(@v,'.',''))

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[tmunson99]

That works. Awesome. Thanks!

 

[bborissov]

Put a star


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP