IBM Support

Enhanced LTRIM() and RTRIM() built-in functions

News


Abstract

The LTRIM function removes any of the specified characters from the beginning of an expression. The RTRIM function removes any of the specified characters from the end of an expression.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements >  Enhanced LTRIM() and RTRIM() built-in functions
For details, see the SQL Reference: LTRIM function, RTRIM function

Enhanced with IBM i 7.3 SF99703 Level 4 and IBM i 7.2 SF99702 Level 16

  • Add trim-expression as an optional 2nd parameter

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
13 January 2020

UID

ibm11142638