Aan de slagGa gratis aan de slag

String functions

There are a number of string functions that can be used to alter strings. A description of a few of these functions are shown below:

  • The LOWER(fieldName) function changes the case of all characters in fieldName to lower case.
  • The INITCAP(fieldName) function changes the case of all characters in fieldName to proper case.
  • The LEFT(fieldName,N) function returns the left N characters of the string fieldName.
  • The SUBSTRING(fieldName from S for N) returns N characters starting from position S of the string fieldName. Note that both from S and for N are optional.

Deze oefening maakt deel uit van de cursus

Reporting in SQL

Cursus bekijken

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

-- Convert country to lower case
SELECT 
	country, 
    ____ AS country_altered
FROM countries
GROUP BY country;
Code bewerken en uitvoeren