# Trim Functions in SSIS


In T-SQL there are many functions there to help do a variety of different things.  SSIS is no different.  In fact, a good number of the commonly used functions from T-SQL are in SSIS as well.  Here we will explore the different Trim functions found in SSIS. We will be using the test phrase "      Test      " to illustrate the three functions: LTRIM, RTRIM and TRIM. **LTRIM (Left Trim):** Just as in T-SQL, this removed empty spaces from the beginning (or left) of a string. ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1716005170500/8a231031-8ae4-47e2-81ea-42feb9a950bc.png) Notice the highlighted result that the trailing spaces are still present but the leading spaces are gone. **RTRIM (Right Trim):** Just as in T-SQL, this removed empty spaces from the end (or right) of a string. ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1716005171233/0a8bd491-2a4e-4d6f-b002-34f8685dc694.png) Notice the highlighted result that the trailing spaces are gone but the leading spaces are still present. **TRIM:** In T-SQL to remove both leading and training spaces you have to nest the trim statements like this: SELECT LTRIM(RTRIM(ColumnName)) AS ColumnName FROM Table. Luckily in SSIS there is a TRIM function that will remove both leading and trailing space in one function called TRIM. ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1716005172181/35fcb69a-f966-45e4-909c-d21a34ecfba4.png) Notice the highlighted result that the trailing and leading spaces are gone.