• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

Convert all data in table to upper case

I'd like to convert all the data in a table to upper case. All fields are strings although some will contain data such as zip codes. What is the most efficient method to accomplish this? This is a task that will be done many times a day (I work with lots of imported data). There's about 20 fields and usually around 20,000 records.
0
carrp
Asked:
carrp
1 Solution
 
malekamCommented:
create this query and run it:

UPDATE my_table
SET field1 = UCASE(field1),
SET field2 = UCASE(field2),
SET field3 = UCASE(field3),
SET field4 = UCASE(field4),
etc...
0
 
GeerdCommented:
Use the Standard build in UCase or UCase$ function!

Grtz G.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now