SQL · String functions

left() / right()

Takes characters from one end. PostgreSQL and SQL Server; SQLite uses substr().

sqlRunnable example sql course

Syntax

left(text, n) / right(text, n)

Example

Open in the lab

SELECT substr('EduByte', 1, 3) AS first_three, substr('EduByte', -3) AS last_three;

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