LTRIM (SSIS Expression)
Applies To: SQL Server 2016
Returns a character expression after removing leading spaces.
Is a character expression from which to remove spaces.
LTRIM 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 LTRIM 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).
LTRIM returns a null result if the argument is null.
This example removes leading spaces from a string literal. The return result is "Hello".
This example removes leading spaces from the FirstName column.
This example removes leading spaces from the FirstName variable.