Truncating strings
In the previous exercise, you calculated the length of the description column and noticed that the number of characters varied but most of the results were over 75 characters. There will be many times when you need to truncate a text column to a certain length to meet specific criteria for an application. In this exercise, we will practice getting the first 50 characters of the description column.
This exercise is part of the course
Functions for Manipulating Data in PostgreSQL
Exercise instructions
- Select the first 50 characters of the
descriptioncolumn with the aliasshort_desc
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
-- Select the first 50 characters of description
___(___, ___) AS ___
FROM
film AS f;