About the Data Vault SQL Reference
Introduction to SQL Reference for Informatica Data Vault
Date and Time Arithmetic
WHERE Clauses
UNION Operator
Parameterized Query
Functions
- Functions Overview
- ABS
- AVG
- CEILING
- CHAR
- COALESCE
- CONCAT
- COUNT
- DATE
- DATE (Date and Time)
- DAY
- DEC
- DIGITS
- EXP
- EXTRACT
- FLOOR
- HOUR
- IFNULL
- INT
- LASTDAY
- LEFT
- LEN
- LN
- LOG10
- LOWER
- LTRIM
- MAX
- MICROSECOND
- MIN
- MINUTE
- MOD
- MONTH
- NANOSECOND
- NULLIF
- PI
- POSITION
- POSSTR
- POWER
- REPLACE
- RIGHT
- ROUND
- RTRIM
- SECOND
- SIGN
- SQRT
- SUBSTRING
- SUM
- TIME
- TODAY
- TRIM
- UPPER
- YEAR

Data Vault SQL Reference

6.4.4
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.3 HotFix 1
- 6.4.3

Back Next

TRIM

A string function that trims the specified character (character
) from the beginning and/or end of the input string (value-expression
) and returns the resulting string. The default trim action is BOTH, and the default character
value is a blank space. Only a single character can be specified for character
. If the specified leading/trailing character is not found, the input expression is returned unchanged.

TRIM Syntax

TRIM ( [  [ LEADING | TRAILING | BOTH ]  [ char character ]  FROM ]  char  value-expression )

TRIM Examples

Input	Output
' midriff '	'midriff'
TRAILING, ' midriff '	' midriff'
LEADING 's' FROM 'ssssSmokin'	'Smokin'

CREATE TABLE string_table (col1 CHAR(20));
INSERT INTO string_table VALUES ('   midriff  ');
1 row affected
SELECT TRIM (col1) FROM string_table;
1 row selected
1
--------------------
midriff
SELECT TRIM(TRAILING FROM col1) FROM string_table;
1 row selected
1
--------------------
   midriff
SELECT TRIM(LEADING 's' FROM 'ssssSmokin') FROM string_table;
1 row selected
1
----------
Smokin

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

TRIM

TRIM

TRIM Syntax

TRIM Examples