How to Use sqlrtrim () and ltrim () Functions

The TRIM function in SQL is used to remove the character header or end of a string. The most common purpose is to remove the leading or trailing blank spaces. This function has different names in different databases: MySQL: TRIM (), RTRIM (), LTRIM () Oracle: RTRIM (), LTRIM () SELECTFIRSTNAME | RTRIM (LASTNAME) AS & quot; TRIM function in WithRTRI SQL is used to remove the character header or tail of a string. The most common purpose is to remove the leading or trailing blank spaces. This function has different names in different databases:

MySQL: TRIM (), RTRIM (), LTRIM ()

Oracle: RTRIM (), LTRIM ()

Select firstname | ''| RTRIM (LASTNAME) AS" With RTRIM "from students where RowNum <11

SELECT
LTRIM (FIRSTNAME) AS "LTRIM"
FROM STUDENTS

SQL Server: RTRIM (), LTRIM ()

Syntax of various trim functions:

TRIM ([[location] [string to be removed] FROM] string): the possible value of [location] is LEADING (start), TRAILING (end ), or BOTH (start and end ). This function removes the [string to be removed] from the start, end, or end of the string. If we do not list what the [string to be removed] is, the blank space will be removed.

LTRIM (string): removes white spaces from the start of all strings.

RTRIM (string): removes the white space at the end of all strings.

WHERE RowNum <11