TRIM()

Available in: DSQL, PSQL

Added in: 2.0

Description

Removes leading and/or trailing spaces (or optionally other strings) from the input string. The result is a VARCHAR(n) with n the formal length of the input string.

Result type: VARCHAR(n)

Syntax

TRIM ([<adjust>] str)

<adjust>  ::= {[where] [what]} FROM

where     ::= BOTH | LEADING | TRAILING /* default is BOTH */

what      ::= The substring to be removed (repeatedly if necessary)
              from str's head and/or tail. Default is ' ' (space).

Examples

select trim (' Waste no space ') from rdb$database
  -- returns 'Waste no space'

select trim (leading from ' Waste no space ') from rdb$database
  -- returns 'Waste no space '

select trim (leading '.' from ' Waste no space ') from rdb$database
  -- returns ' Waste no space '

select trim (trailing '!' from 'Help!!!!') from rdb$database
  -- returns 'Help'

select trim ('la' from 'lalala I love you Ella') from rdb$database
  -- returns ' I love you El'

select trim ('la' from 'Lalala I love you Ella') from rdb$database
  -- returns 'Lalala I love you El'