How to count the number of commas (',') in a SQL table column?

Question

I have a table in Teradata. This table has a column named text_column that contains some text in format varchar(25).

I need to count the number of ',' in this column.

The so-called duplicate was not for Teradata and the answer doesn't even work in Teradata. — Gordon Linoff, Jul 22 '21 at 05:50

score 1 · Answer 1 · answered Jul 21 '21 at 14:48

1

One method uses the difference of lengths of strings:

select ( character_length(text_column) - character_length(oreplace(text_column, ',', '')) as num_columns

answered Jul 21 '21 at 14:48

Gordon Linoff

1 Answers1