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 vote191 views1 answer
Rename view mysql
SQL
1 vote199 views1 answer
Date in where on datetime column clause mysql
SQL
25 votes194 views5 answers
Date in mysql
SQL
1 vote182 views2 answers
Find a column in all tables mysql
SQL
5 votes180 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote230 views1 answer
Sql check if field is not null
SQL
0 vote201 views1 answer
Str_to_date sql server
SQL
0 vote190 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote179 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote158 views1 answer
What are the cursors and what are the cursors types? in sql
SQL