You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

RIGHT

Extracts the specified number of characters from the right end of a string

Syntax

RIGHT(str, len)

Arguments

  • str: any string or binary object
  • len: the number of characters to be extracted

Return Type

String

Examples

memsql> select right("1234567", 3);
+---------------------+
| right("1234567", 3) |
+---------------------+
| 567                 |
+---------------------+

Related Topics