Working on some legacy software that is kind of wobbly, found a quick way (hopefully) to stabilize it but need to run some queries on the tables to make some columns entirely UPPER CASE. Any ideas?
+11
A:
Permanent:
UPDATE
MyTable
SET
MyColumn = UPPER(MyColumn)
Temporary:
SELECT
UPPER(MyColumn) AS MyColumn
FROM
MyTable
Tomalak
2009-05-13 15:05:45
+1 Your doing a much better job on these SQL questions than me :)
Dead account
2009-05-13 15:07:47
But you get a badge for deleting an answer with 3 upvotes. :-)
Tomalak
2009-05-13 15:08:47
the temporary one is not working
shogun
2009-05-13 15:09:16
In what way is it not working?
Tomalak
2009-05-13 15:12:01
nevermind I typoed my table name ;)
shogun
2009-05-13 15:13:05