• ⌂ Text
• Functions
  • CHAR_LENGTH()
  • CONCAT()
  • ENUM()
  • FIND_ALL_IN_SET()
  • FIND_ANY_IN_SET()
  • FIND_IN_SET()
  • INSTR()
  • LEFT()
  • LENGTH()
  • LOCATE()
  • LOWER()
  • LPAD()
  • LTRIM()
  • MATCHES()
  • ORD()
  • REVERSE()
  • RIGHT()
  • RPAD()
  • RTRIM()
  • SUBSTR()
  • SUBSTRING()
  • TRIM()
  • UPPER()

RTRIM()

Returns a string with trailing space characters removed.  Returns NULL if the string is NULL.

Prototype

string RTRIM(string str)

Parameters

• str - The string to remove the trailing space characters from.

Return

Returns str with trailing space characters removed.  Returns NULL if the str is NULL.

Example

Remove trailing spaces from a contact name.

SELECT RTRIM(Name) AS TrimmedName FROM Contact

Related

LTRIM(), TRIM()

• < RPAD()
• SUBSTR() >