Functions convertes text to Title Case

[chuckcou]

I found the lower()and upper() function. I also know I could filter the data.

What I want to do is replace the data permently.

Current data

[color:red]UNITED STATE OF AMERICA

===>United State Of America

Any idea on function because I couldn't find it?

Thanks

Chuck

[jteich]

Records -> Replace Field Contents

Careful, make Backup first

-jens

[Ender]

In the case of your example, use the Proper() function.

[chuckcou]

Ender Ah, it is proper(). Missed that one. Got it thanks.

jteich : Ya, that how I am going to do it. I agree with the backup, learned that one the hard way. Thanks, chuck