Trim Function
Wed, 03/04/2009 - 20:02 | 
hdanzl
Syntax
|
TRIM ( [ [ <trim specification> ] [ <trim character> ] FROM ] <trim source> |
|
| | |
LEADING TRAILING BOTH |
<trim character> ::= <character value expression>
<trim source> ::= <character value expression>
Notes
| ♦ | The TRIM function removes leading and/or trailing characters from the source string. |
| ♦ | If no trim specification is specified, then BOTH is implicit. |
| ♦ | If no trim character is specified, then space is implicit. |
| ♦ | If the declared type of the trim source is a fixed-length or variable-length character string type, then the data type of the result is CHARACTER VARYING or NATIONAL CHARACTER VARYING with a length equal to the fixed length or maximum variable length of the trim source, otherwise the data type of the result is CHARACTER LARGE OBJECT or NATIONAL CHARACTER LARGE OBJECT. |
| ♦ | If either of the arguments are null, then the result is null. |
Examples
|
Expression |
Result |
|
TRIM( ' Meet the Dream Team ' ) |
'Meet the Dream Team' |
|
TRIM( BOTH FROM ' Meet the Dream Team ' ) |
'Meet the Dream Team' |
|
TRIM( LEADING 'M' FROM 'Meet the Dream TeaM' ) |
'eet the Dream TeaM' |
|
TRIM( TRAILING 'M' FROM 'Meet the Dream TeaM' ) |
'Meet the Dream Tea' |
|
TRIM( BOTH 'M' FROM 'Meet the Dream TeaM' ) |
'eet the Dream Tea' |
Conformance
|
SQL:2003 standard |
- |
Core SQL |
Tags:
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
Site Updates
- May 27 2025 - 2:55pm
- May 14 2025 - 12:32pm
- Mar 19 2025 - 9:52pm
- Mar 14 2025 - 11:23am
- Mar 13 2025 - 11:42pm