I've had a fair look around the net and these forums, but haven't had much finding an answer to this problem. I have column in a table that's defined as a primary key, varchar, 3 max. I need to capitalize all the letters (not just the first leter) in this column. I wonder-- is there a MySQL query I could use to do this?

Fou-Lu

04-08-2013, 05:45 PM

Sure is; you can use either UCASE() or UPPER() functions. Both of them should return the results of the string in complete upper case.

superwookie

04-09-2013, 06:17 PM

I'm actually not trying to return the values in uppercase, I'm trying to manipulate the data currently in the table so all the values in one column are in ALL CAPS.