Takes the given number of characters from the end of a string.
RIGHT(<text>, <count>)
RIGHT(phone, 3) gives the last three characters. A negative count means “everything except the start”: RIGHT(<text>, -4) drops the first four characters. Its mirror function is LEFT, which takes characters from the start.
employees
| name | department | salary | bonus | phone |
|---|---|---|---|---|
| Emma | backend | 1200 | 300 | +44 7700 900123 |
| Liam | backend | 1000 | NULL | NULL |
| Olivia | frontend | 1350 | 150 | +44 7700 900456 |
| Noah | frontend | 950 | NULL | +44 7700 900789 |
| Sophia | design | 1200 | 200 | NULL |
These tables already exist in the sandbox — the examples below use them. Want to try this in your own database? Copy the SQL.
| last_three |
|---|
| SQL |
| name | last_digits |
|---|---|
| Emma | 123 |
| Liam | NULL |
| Olivia | 456 |
| Noah | 789 |
| Sophia | NULL |
| number_part |
|---|
| 00042 |
We drop the four characters ORD- and keep the number.
A negative count isn't an error — it means “everything except the first ones”: RIGHT('abc', -1) gives bc. If the count comes from an expression that happens to turn negative, there won't be an error.
A count larger than the length isn't an error either: RIGHT('SQL', 10) simply returns SQL.
Trailing spaces are characters too: in 'Emma ' the last character is a space. Remove them first with TRIM.