Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

LEFT (SSIS Expression)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns the specified number of characters from the leftmost portion of the given character expression.



Is a character expression from which to extract characters.


Is an integer expression that indicates the number of characters to be returned.

If number is greater than the length of character_expression, the function returns character_expression.

If number is zero, the function returns a zero-length string.

If number is a negative number, the function returns an error.

The number argument can take variables and columns.

LEFT works only with the DT_WSTR data type. A character_expression argument that is a string literal or a data column with the DT_STR data type is implicitly cast to the DT_WSTR data type before LEFT performs its operation. Other data types must be explicitly cast to the DT_WSTR data type. For more information, see Integration Services Data Types and Cast (SSIS Expression).

LEFT returns a null result if either argument is null.

The following example uses a string literal. The return result is "Mountain".

LEFT("Mountain Bike", 8)

Community Additions

© 2015 Microsoft