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 vote232 views1 answer
Sql find column name like
SQL
1 vote225 views1 answer
Mysql find tables with column name
SQL
0 vote232 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
1 vote181 views1 answer
Oracle compile schema
SQL
0 vote224 views1 answer
How to insert same table data using mysql query
SQL
0 vote261 views1 answer
Mysql remove bad character from all fields
SQL
0 vote234 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote222 views1 answer
Login phpmyadmin without password
SQL
1 vote237 views1 answer
Get table which have specific columns in mysql
SQL
1 vote232 views2 answers
Update with inner join sql server
SQL