Home / Computer & Internet / Microsoft SQL Server / New String functions in SQL Server 2017
SQL Server Logo

New String functions in SQL Server 2017

TRIM

SQL Server developers were requesting this function since very long. SQL Server do have RTRIM and LTRIM functions to remove spaces from left and right side of the given text. However, to remove spaces from both sides, RTRIM and LTRIM must be nested.

For instance:

newly added TRIM function can remove spaces from both side. Above code can be simplified as following: