SQL query to make all data in a column UPPER CASE

Question

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

User · Accepted Answer

Permanent   UPDATE   MyTable SET   MyColumn   UPPER MyColumn    Temporary   SELECT   UPPER MyColumn  AS MyColumn FROM   MyTable

User · Answer

If you want to only update on rows that are not currently uppercase  instead of all rows   you d need to identify the difference using COLLATE like this   UPDATE MyTable SET    MyColumn   UPPER MyColumn  WHERE  MyColumn    UPPER MyColumn  COLLATE Latin1 General CS AS      A Bit About Collation  Cases sensitivity is based on your collation settings  and is typically case insensitive by default   Collation can be set at the Server  Database  Column  or Query Level   -- Server SELECT SERVERPROPERTY  COLLATION   -- Database SELECT name  collation name FROM sys databases -- Column  SELECT COLUMN NAME  COLLATION NAME FROM INFORMATION SCHEMA COLUMNS WHERE CHARACTER SET NAME IS NOT NULL   Collation Names specify how a string should be encoded and read  for example    Latin1 General CI AS   Case Insensitive Latin1 General CS AS   Case Sensitive

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

Examples related to sql

Examples related to uppercase