Quiz: Advanced SQL Tutorial | String Functions + Use Cases

Test your knowledge on key concepts from this video.

1. The SQL function ______ is used to remove blank spaces from both the left and right sides of a string.

2. To remove only the blank spaces from the left side of a string, you would use the ______ SQL function.

3. The ______ SQL function is specifically designed to remove blank spaces from the right side of a string.

4. To change a specific value within a string, such as replacing “dash fired” with nothing, you would use the ______ function.

5. The ______ function allows you to extract a specific portion of a string by defining a starting position and the number of characters to include.

6. A common application of the SUBSTRING function, as demonstrated in the video, is ______, which helps match similar but not identical string values across tables.