Funktion LOWER/UPPER sql

Uppercase and lowercase in sql

select UPPER('converted to upper');
select LOWER('CONVERTED TO LOWER');

Funktion LOWER/UPPER sql

LOWER/UPPER
LOWER wandelt eine String in eine in Kleinbuchstaben um. 
UPPER ist das Gegenstück zu LOWER, und wandelt den String 
in Grossbuchstaben um.

SELECT LOWER (expression)

SELECT UPPER (expression)

Similar codes

0 vote215 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote232 views2 answers
How to tun mysql on ubunto
SQL
0 vote224 views1 answer
Mysql table variables
SQL
0 vote247 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote214 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
-1 vote178 views3 answers
Ubuntu install mssql
SQL
0 vote235 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
1 vote229 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote218 views1 answer
Pl sql search in all packages
SQL
2 votes228 views1 answer
Query any digits record
SQL