您如何计算SQL varchar中某个子字符串出现的次数?

I have a column that has values formatted like a,b,c,d. Is there a way to count the number of commas in that value in T-SQL?I have a column that has values formatted like