Changing Case

R

Roger Bell

I know how to use the "strconv" command to change case for a particular field
with an Update query. Is there a way you can select all the fields and
change the case to all fields in a single Update Quey?
Thanks for any help
 
J

John W. Vinson

I know how to use the "strconv" command to change case for a particular field
with an Update query. Is there a way you can select all the fields and
change the case to all fields in a single Update Quey?
Thanks for any help
Click to expand...

Just put as many StrConv() calls as you need in the Update To line. You can
update many fields in one update query.

The SQL would be something like

UPDATE mytable
SET ThisField = StrConv([ThisField], 1),
ThatField = StrConv([ThatField], 1),
TheOtherField = StrConv([TheOtherField], 1);

to update three fields to upper case.

John W. Vinson [MVP]
 
Top