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

14 votes204 views1 answer
Oracle new column
SQL
0 vote253 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
1 vote187 views3 answers
Union SQL
SQL
0 vote259 views1 answer
Php insert null mysql
SQL
0 vote221 views1 answer
Delete first row in sql
SQL
0 vote189 views1 answer
Sql sum if
SQL
0 vote214 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote203 views1 answer
How to join result table in mysql
SQL
23 votes185 views6 answers
How to create table in sql
SQL
0 vote198 views2 answers
Call to undefined function mysqli_fetch_all()
SQL