Скачать или смотреть TRIM, LTRIM, RTRIM Function in SQL Server | Part 21

TRIM, LTRIM, RTRIM Function in SQL Server | Part 21


In SQL Server, the TRIM, LTRIM, and RTRIM functions are used to manipulate strings by removing leading and trailing spaces (or other specified characters) from a string. These functions are helpful for cleaning up data and ensuring consistent formatting. Here's an explanation of each function:

TRIM Function:

The TRIM function is used to remove leading and trailing spaces (or other specified characters) from a string.
It was introduced in SQL Server 2017 and later versions.
The syntax for using TRIM is as follows:
sql
Copy code
TRIM([{characters FROM}] string)
{characters FROM} is an optional clause that allows you to specify a set of characters other than spaces to be removed. If not specified, it removes spaces by default.
Example:

sql
Copy code
SELECT TRIM(' Hello ') AS TrimmedString;
-- Output: 'Hello'
LTRIM Function:

The LTRIM function (Left Trim) is used to remove leading spaces (or other specified characters) from a string.
It has been available in SQL Server for a long time.
The syntax for using LTRIM is as follows:
sql
Copy code
LTRIM([{characters FROM}] string)
{characters FROM} is an optional clause, similar to the TRIM function, allowing you to specify characters other than spaces to be removed from the left side of the string.
Example:

sql
Copy code
SELECT LTRIM(' Hello ') AS LeftTrimmedString;
-- Output: 'Hello '
RTRIM Function:

The RTRIM function (Right Trim) is used to remove trailing spaces (or other specified characters) from a string.
It has also been available in SQL Server for a long time.
The syntax for using RTRIM is as follows:
sql
Copy code
RTRIM([{characters FROM}] string)
{characters FROM} is an optional clause, similar to the TRIM function, allowing you to specify characters other than spaces to be removed from the right side of the string.
Example:

sql
Copy code
SELECT RTRIM(' Hello ') AS RightTrimmedString;
-- Output: ' Hello'
These functions are useful for data cleaning and formatting tasks in SQL Server, particularly when working with strings that may have extra spaces or unwanted characters at the beginning or end. Depending on your specific requirements, you can use TRIM, LTRIM, or RTRIM to achieve the desired results.