Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateInternal functions → TRIM()
Firebird Home Firebird Home Prev: SUBSTRING()Firebird Documentation IndexUp: Internal functionsNext: UPPER()

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'
Prev: SUBSTRING()Firebird Documentation IndexUp: Internal functionsNext: UPPER()
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateInternal functions → TRIM()