Built-In Functions and Syntax › Extract

Extract

The extract function returns the string that results from removing leading and trailing spaces from a string value.

Syntax:

►►─┬─ EXT ─────┬─ (string) ───────────────────────────────────────────────────►◄
   └─ EXTRACT ─┘

Invocation names:

EXT
EXTRACT

Parameters:

(string)

Specifies the string value on which the extract function is performed.

Example:

This example removes leading and trailing spaces from the string contained in EMP-LAST-NAME-0415. The value of EMP-LAST-NAME-0415 is ' VON BUREN '

select extract(emp-last-name-0415) from employee

  'VON BUREN'