Update Table using Query

  • Thread starter Thread starter Megan
  • Start date Start date
M

Megan

Is there a query that could update the first letter of the
whole column in my table to uppercase?

If so what would be the criteria?
 
Hi,


Make a backup.

Then, try


UPDATE myTable
SET field1 = UCase(Left(field1, 1)) & Mid(field1, 2)



There is no criteria if you want to do that for all the records.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top