[andrew]

A SQL column, street, in the address table, has values with multiple lines that are separated with carriage returns. Write me a SQL query to return only the last line of the street field, ignoring all previous lines.

[rpgking]

SELECT SUBSTRING_INDEX(street, '\r', -1) FROM address;

[andrew]

SELECT SUBSTRING_INDEX(street, '\r', -1) FROM address;

Doesn't work in SQL 2016. Substring_index is not a valid function. I guess I should have specified sql 2016.  :0