T-SQL question: how to count number of char in a text field?

Question

Dear All,

how can i use t-sql to count the number of char in a text field?

for example:
text: '123,Jimmy,Assigned a job, close the job'

I need to cout number of ',' in this text, so output for this example is 3

What is the code in T-SQL?

Many Thanks

Answer 1

I believe that this is the link you are looking for.