Left and right
We can retrieve portions of a string from either the start of the string, using LEFT
, or working back from the end of the string, using RIGHT
.
This exercise is part of the course
Introduction to SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Select the first 25 characters from the left of the description column
SELECT
___(description, ___) AS ___
FROM
grid;