Let's practice! - String

Retrieve the length of the description column, returning the results as description_length.

SELECT ........... (...........) AS ........... FROM grid;

• Retrieve the first 25 characters from the description column in the grid table. Name the results first_25_left.

SELECT ...........(...........,...........) AS ........... FROM grid;

• Amend the query to retrieve the last 25 characters from the description. Name the results last_25_right.

SELECT LEFT(description, 20) AS ........... FROM grid;

• Edit the query to return the CHARINDEX of the string 'Weather' whenever it appears within the description column.

SELECT description, ..........('..........', description) FROM grid

WHERE description LIKE '%Weather%';

• Fill in the blank

• Complete the substring function to begin extracting from the correct character in the description column.

SELECT description, CHARINDEX('Weather', description) AS start_of_string,

LEN ('Weather') AS length_of_string,

SUBSTRING(______,______,______) AS additional_description

FROM grid

WHERE description LIKE '%Weather%';