FirebirdSQL logo
 Procedural SQL (PSQL) StatementsAggregate Functions 

TRIM 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'

UNICODE_CHAR()

Character from Unicode code point

Result type

CHAR(1) CHARACTER SET UTF8

Syntax
UNICODE_CHAR (code)
Table 1. UNICODE_CHAR Function Parameter
Parameter Description

code

The Unicode code point (range 0…​0x10FFFF)

Returns the character corresponding to the Unicode code point passed in the argument.

See also

[fblangref50-scalarfuncs-unicode-val], [fblangref50-scalarfuncs-ascii-char]