>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 ?
replace all myfield with upper(myfield) in mytable && replaces current value with all caps
replace all myfield with proper(myfield) in mytable && replace current value with capital/lower case combination
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao