I am using ASE 11.x. I need to write a SQL statement that will return a count of substring occurances in a varchar column.
I tried doing something like this
select char_length('a.b.c') - char_length(replace('a.b.c', '.', ' ')) but looks like ASE 11.x does not support replace function.
How do I get, for example, a count of '.' in string, 'a.b.c' using ASE 11.x T-SQL?