Monday, November 28, 2011

Count No.Of character occurences on a string

DECLARE @String  VARCHAR(500) = 'Sequel Server 2012 ',
        @Char     CHAR(1)    = 'e'
       
       
SELECT DATALENGTH(REPLACE  (@String, @Char, @Char+@Char)) - DATALENGTH (@String) As CharacterCount


Result
------
4

No comments:

Post a Comment