By 25/02/2016 1 Comments

What Are UCASE() & UPPER() Functions In SQL?

  • SQL UCASE() and UPPER() functions areĀ used to convert the string values of a table column in uppercase letters.
  • The UCASE() function is used in MySQL database system.
  • The UPPER() function is used in SQL Server database system.

Syntax for MySQL:

SELECT UCASE(column) FROM table_name;

Example:

SELECT id, UCASE(product_name) AS "Products", price
FROM products;

Syntax for SQL Server:

SELECT UPPER(column) FROM table_name;

Example:

SELECT id, UPPER(product_name) AS "Products", price
FROM products;






Posted in: Sql

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .