Counting Letters in a Name

[avw]

I have tried this in numerous Data Bases with no luck.

Suppose: I have a name that contains the letter "I" such as Blaine.
I want to count the letters but make the "I" count as a "half" letter. In other words Blaine would be totaled as 5.5 letters.

Any ideas?

 

[Schlogg]

Result = 0.5 * ((length(name) * 2 ) - patterncount(name, "l&quot)

Cheers,
Paul J.

 

[avw]

Paul,

Many thanks for the help. I had just begun reading the info on "pattern" when I seen your answer.

This helps immensely.

Marion