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.
Syntax
TRIM([<LEADING | TRAILING | BOTH>][pad][FROM] string)
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,
white space will be removed.
FROM
DO NOT USE if LEADING, TRAILING, or BOTH keyword was NOT specified.
string
Required. The string that will be "trimmed".
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
|