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

1 vote220 views1 answer
Data type and their numeric form
SQL
0 vote225 views1 answer
Connect by query in oracle
SQL
1 vote205 views1 answer
Display total number of tables in mysql
SQL
1 vote249 views1 answer
Nullif postgresql
SQL
0 vote218 views1 answer
How to reset the database value in SQL server
SQL
0 vote233 views1 answer
Nodejs sql get one to many relationship as array
SQL
1 vote229 views2 answers
Check if word is in column sql
SQL
16 votes221 views2 answers
Add column if not exists mysql
SQL
1 vote257 views1 answer
Oracle drop temporary table
SQL
0 vote238 views1 answer
Mysql update from select on same table
SQL