SQL · String functions

substr() with negative start

A negative start counts from the end of the string.

sqlRunnable example sql course

Syntax

substr(text, -n)

Example

Open in the lab

SELECT substr('EduByte', -4) AS tail;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.