Siebel VB Language Reference > VB Language Reference >

Trim Function


This standard VB function returns a copy of a string after removing leading and trailing spaces.

Syntax

Trim[$](string)

Argument
Description

string

A literal or expression from which leading and trailing spaces are to be removed

Returns

A copy of string with leading and trailing spaces removed.

Usage

Trim accepts expressions of type string. Trim accepts any type of string, including numeric values, and converts the input value to a string.

The dollar sign ($) in the function name is optional. If it is included, the return type is string. Otherwise the function typically returns a variant of vartype 8 (string). If the value of string is NULL, a variant of vartype 1 (Null) is returned.

Example

For an example, read LTrim Function.

Related Topics

Left Function
Len Function
LTrim Function
Mid Function
Mid Statement
Right Function
RTrim Function

Siebel VB Language Reference Copyright © 2006, Oracle. All rights reserved.