Count the No. of Occurence

Database
Enthusiast

Count the No. of Occurence

Hi,

Is there any function to find the number of occurences of a particular substring within a string in teradata?
2 REPLIES
WAQ
Enthusiast

Re: Count the No. of Occurence

I don't think that there is any direct function available for this purpose. Probably you can have a UDF that count the no of occurances in the string.
Enthusiast

Re: Count the No. of Occurence

No, there is no such a built in function in teradata.