Urgent :)

[yxez]

hi friends,

Is there a function to count how many words does a varchar2 column contains?

Thanks

[hrishy]

Hi

The answer is nope.

However depending upon your data you can try to use the avaliable string functions like length replace etc to get what you want.

regards
Hrishy

[slimdave]

Number of spaces + 1?

Compare length of original string with length of string with spaces removed. Maybe regexp could do it also

[yxez]

thanks hunnies