DECLARE @longWord varchar(28)='AntiDisEstablishmentArianism'SELECT CountCharacters =DATALENGTH(@longWord)- DATALENGTH (REPLACE(REPLACE(LOWER(@longWord),'a',''),'i',''))
Showing posts with label Occurrence of Character in a String. Show all posts
Showing posts with label Occurrence of Character in a String. Show all posts
Tuesday, November 23, 2010
Count the Number of Occurrence of Character in a String – SQL Server Challenge
Subscribe to:
Posts (Atom)