All Forums Database
Kishore_1 208 posts Joined 03/10
26 Dec 2010
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?

WAQ 158 posts Joined 02/10
26 Dec 2010

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.

teradater 29 posts Joined 11/10
28 Dec 2010

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

You must sign in to leave a comment.