...

View Full Version : Capitalize all values in column



superwookie
04-08-2013, 04:56 PM
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, 06: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, 07: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.

Thanks again for the help!

Fou-Lu
04-09-2013, 07:21 PM
Same principle, use an UPDATE statement with it.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum