The others have shown how to do the actual replacement but you may want to look at file#
9547 Upper/Lower to replace PROPER() under files->win32 apis and other, it's file #
9126. It will help properly case names.
hth
>I have a table which contains more than 3,000
> names of people with capital and no capitals
>
> How can I do to transform all into capitals ?
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!