Change case of a string in sql to uppercase or lowercase

UPDATE TableName SET ColumnName = UPPER(ColumnName) UPDATE TableName SET ColumnName = LOWER(ColumnName)