SQL Server query to calculate number of A in string

Posted by Amatya under Sql Server category on 9/26/2017 | Points: 40 | Views : 2635

SQL Server query to calculate number of A in string 'DOTNETFUNDA-AMATYA'.

  Select LEN('DOTNETFUNDA-AMATYA') - LEN (REPLACE('DOTNETFUNDA-AMATYA', 'A', '')) as ACount

Output
4

Thanks
Amatya

Bookmark It

Latest Code Snipptes