table convertion to uppercase

edmundus · Apr 16, 2000

how do I update a column in a table in microsoft access to all uppercase or all lowercase in one step.

Zelandakh · Apr 17, 2000

column called field1 in table table1. UPDATE field1 SET table1.field1=ucase(table1.field1);

DougP · Apr 17, 2000

you could create an "Update" Query with UCase([myfield]) Make a new query Add the table you want to update Click the "Query" menu then "Update Query" Drag the field you wan to make uppercase down to the grid. In the "Update To:" box put UCase([myfield]) where myfield is the name of your field. then run it. I would also suggest that you make a copy of your Table before you run any update, append or delete query. Cause you can not reverse the results if its wrong.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

table convertion to uppercase

edmundus

Vendor

Zelandakh

MIS

DougP

MIS

Similar threads

Part and Inventory Search

Sponsor