Export (0) Print
Expand All

Trim String Transformation

SQL Server 2000

Trim String Transformation

The Trim String transformation removes leading, trailing, and embedded white space from a string in the source column and copies the result to the destination column.

White space consists of the following characters: tab, line feed, vertical tab, form feed, carriage return, and space (0x09 – 0x0D, 0x20), as well as their Unicode equivalents.

You may optionally convert the trimmed string to either uppercase or lowercase characters.

If the trimmed source data is too large to fit in the destination column, it is truncated.

The Trim String transformation fails if the source or destination columns are not of a string data type.

To perform a Trim String transformation

Enterprise Manager

See Also

DTS Transformations

DataPumpTransformTrimString Object

Trim String Transformation Properties

© 2014 Microsoft