SQL query to make all data in a column UPPER CASE?

sql uppercase
CloudMeta picture CloudMeta · May 13, 2009 · Viewed 207.3k times · Source

I need a SQL query to make all data in a column UPPER CASE?

Any ideas?

Answer

Tomalak picture Tomalak · May 13, 2009

Permanent:

UPDATE
  MyTable
SET
  MyColumn = UPPER(MyColumn)

Temporary:

SELECT
  UPPER(MyColumn) AS MyColumn
FROM
  MyTable

Related questions

SQL Server: Make all UPPER case to Proper Case/Title Case

I have a table that was imported as all UPPER CASE and I would like to turn it into Proper Case. What script have any of you used to complete this?

Read More
SQL changing a value to upper or lower case

How do you make a field in a sql select statement all upper or lower case? Example: select firstname from Person How do I make firstname always return upper case and likewise always return lower case?

Read More
How to find values in all caps in SQL Server?

How can I find column values that are in all caps? Like LastName = 'SMITH' instead of 'Smith' Here is what I was trying... SELECT * FROM MyTable WHERE FirstName = UPPER(FirstName)

Read More