RE: Update a Field in a table to Uppercase

[snip] Does anyone have a sample of a simple update statement I can run to update a field in a table to all uppercase values. [/snip] UPDATE mytable SET mycol=UPPER(mycol); --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives:

Update a Field in a table to Uppercase

Does anyone have a sample of a simple update statement I can run to update a field in a table to all uppercase values. Any help or web references are appreciated.