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 vote338 views1 answer
Convert sql server guid to varbinary
SQL
-1 vote363 views2 answers
First letter capital in mysql query
SQL
0 vote398 views1 answer
Oracle winter time change
SQL
0 vote340 views1 answer
Postgre admin slow
SQL
0 vote371 views1 answer
Generate random & unique mysql string
SQL
0 vote351 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote391 views1 answer
FIND most frequent word in sql server
SQL
8 votes343 views1 answer
Unique vs primary key
SQL
0 vote356 views1 answer
Update view sql
SQL
-1 vote355 views1 answer
MYSQL stored procedure select from
SQL