Question entretien chez The Resource Group : SQL query to count the occurrences of character 'R' in a string.

The Resource Group

SQL query to count the occurrences of character 'R' in a string.

Utilisateur anonyme

6 oct. 2014

Didn't have the answer

Utilisateur anonyme

15 juin 2021

I posted the answer using a query (recursive by using CTE of SQL SERVER) Cell: 03343965257

Utilisateur anonyme

1 sept. 2022

Select round(length(desc) length(replace(desc,”R”,””)))/length(“R”)) as count_r From table