TRAILING

TRAILING is an SQL property used in the TRIM() function to remove specified characters from the end of a string value. The characters can be spaces or other specified characters. It helps in refining and cleaning data within SQL databases.

Example

SELECT TRIM(TRAILING '0' FROM '9000');

Output

'9'

Explanation

The TRIM(TRAILING ... ) function in MySQL removes the trailing character that is specified in the parentheses. In the above example, it removes trailing ‘0’ from ‘9000’. The output becomes ‘9’ after removal of trailing zeros.

Example

SELECT TRIM(TRAILING FROM 'PostgreSQL  ');

Output

'PostgreSQL'

Explanation

The TRIM(TRAILING FROM string) function in PostgreSQL is used to remove any trailing whitespaces from the specified string. In the given example, trailing whitespaces from the string ‘PostgreSQL ’ are removed, resulting in ‘PostgreSQL’.

Example

SELECT TRIM(TRAILING '0' FROM '7000') AS TrimmedString
FROM dual;

Output

TrimmedString
-------------
700

Explanation

The TRIM() function in this example removes (trims) any trailing ‘0’ characters from the string ‘7000’. The result is ‘700’.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.