Count elements in string

Viewed 65

I have string: '001;002;005' I want count ; in my string.

e.g.:

select count('001;002;005', expression)

returns 2

select count('001;002;005;006', expression)

returns 3

2 Answers
Related