CAPFIRST(<expC>)
Capitalizes the first letter of each word, lowercases the rest.
Returns lowercase <expC> with first alpha character of each word uppercase.

Useful where database files contain entries that are all uppercase,
all lowercase, or randomly mixed.

A new word is considered to begin with the first character
immediately following a space or hyphen.

USE File && close when no longer needed
* Display from a database file with bad cases
? CAPFIRST(TRIM(Firstname)), CAPFIRST(Lastname)
? CAPFIRST(Address)
* Fix a database file with bad case entries
REPLACE ALL Lastname WITH CAPFIRST(Lastname),;
Firstname WITH CAPFIRST(Firstname),;
Address WITH CAPFIRST(Address)


Placed in the Public Domain by Tom Rettig Assoc.