TRIM() function came with MS SQL Server 2017. Previously, we used to handle spaces in the variable with methods such as LTRIM, RTRIM or REPLACE.

With the TRIM() function, we can remove the leading and trailing spaces as well as the characters.

There are 2 different usage patterns. In the first, if only the variable is written inside the TRIM function, it takes the leading and trailing spaces.

SELECT TRIM(' develop ')

The second usage is a little different. The desired characters are written in order and the value to be trimmed is specified using FROM. Typed characters are removed from the beginning and end of the value.

SELECT TRIM('.$_' FROM '$$_develop1..')