SQL Functions

TRIM

The TRIM function removes any leading and/or trailing pad characters from a string. The pad character is a single character and defaults to a space character.

LTRIM(string) and RTRIM(string) are supported ONLY in Omnidex SQL Plus.

Syntax

TRIM([<LEADING | TRAILING | BOTH>][pad][FROM] string)

TRIM()

Required.

LEADING | TRAILING | BOTH

Optional. Specifies if the leading, trailing or both leading and trailing pad characters will be removed from a string. If omitted, the FROM keyword must also be omitted. BOTH is the default.

pad

Optional. Specify the pad character that is to be removed. If omitted, whitespace will be removed.

FROM

DO NOT USE if LEADING, TRAILING, or BOTH keyword was NOT specified.

string

Required. The string that will be "trimmed".

top

Example

select company, trim(contact) from customers where company='systems'

select company, trim(LEADING FROM contact) from customers where company='systems'

select company, trim(TRAILING ',' FROM contact) from customers where company='systems'

top