Count the Comma Separated Values in SQL SERVER

this is usefull when you write data like(abc,zxy)in table

SELECT

      LEN(field name) - LEN(REPLACE(field name, ',', ''))+1 total

From [your table name]

SELECT

      LEN(word) - LEN(REPLACE(word, ',', ''))+1 total

From dbo.test