MVSFORUMS.com

[ranjit5311]

Hi,

I required to check the count of chacters present in a column's value of a table. The column is defined as char(150). So I am not able to use LENGTH funtion.

E.g:-
Column Value
-----------------
abc
ab
defg

Result:-

3
2
4

Could any one suggest how the above objective can be achived.

Thanks,
Ranjit
_________________
One should move lightly through the life, carrying no excess baggage.

[kolusu]

ranjit5311,

Try this