select UPPER('converted to upper');
select LOWER('CONVERTED TO LOWER');
SELECT upper('Hello World'); -- HELLO WORLD
SELECT lower('Hello World'); -- hello world
SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
FROM CUSTOMERS ;
Code Example |
---|
Sql :: lower case in sql |
Sql :: mysql loop |
Sql :: declare table variable sql |
Sql :: nvl in oracle |
Sql :: mysql count rows returned |
Sql :: /bin/sh: 1: mysql_config: not found |
Sql :: mysql add to value |
Sql :: sql not equal |
Sql :: Get all index postgres |
Sql :: t-sql random number for each row |
Sql :: sql server create database |
Sql :: oracle sql for each row |
Sql :: oracle default date format |
Sql :: sql right characters |
Sql :: sql server default port |
Sql :: sql inserted |
Sql :: oracle enable chain |
Sql :: uncheck constraints and delete from table |
Sql :: oracle create package body |
Sql :: sql server version check |
Sql :: nth highest salary in sql |
Sql :: mysql dump for selected row |
Sql :: call function in query sql server |
Sql :: SQL add a totals of differemt rows of the same id |
Sql :: oracle drop default value |
Sql :: commit transaction sql |
Sql :: psql show db |
Sql :: mysql group by |
Sql :: display first three characters sql |
Sql :: how to put is null in where in clause |