SQL RIGHT

The mirror of LEFT — grabs the last N characters, counting from the end of the string.

What & Why

RIGHT(text, n) returns the last n characters of a string.

BUSINESS QUESTION

Marketing wants the last four characters of every campaign name for a compact label.

id	name	channel	spend	start_date	end_date	status	target_segment
1	Spring Launch	google_ads	55000.00	2024-01-15	2024-03-31	active	smb
2	Retention Webinar	email	45000.00	2024-02-10	2024-04-15	active	enterprise
3	Finance Retargeting	linkedin	50000.00	2024-03-12	2024-05-31	active	enterprise
4	Enterprise Search	google_ads	60000.00	2024-04-01	2024-06-30	active	enterprise

EXAMPLE QUERY

SELECT
  id AS campaign_id,
  name,
  RIGHT(name, 4) AS name_suffix
FROM marketing.campaigns
ORDER BY campaign_id;

RESULT — exact output from the displayed Queryflo rows

RIGHT returns the final four characters of each campaign name.

Now You Try

Marketing wants the last four characters of every campaign name for a compact label.

Available schema

marketing

Prefix tables with marketing.table_name.

campaign_idnamename_suffix

marketing.campaigns

query.sql