Rtrim sql

SELECT TRIM('   Exemple   ');						-- 'Exemple'
SELECT LTRIM('   Exemple   ');						-- 'Exemple   '
SELECT RTRIM('   Exemple   ');						-- '   Exemple'
SELECT TRIM(BOTH 'x' FROM 'xxxExemplexxx');			-- 'Exemple'
SELECT TRIM(LEADING 'x' FROM 'xxxExemplexxx');		-- 'Exemplexxx'
SELECT LTRIM('xxxExemplexxx', 'x');					-- 'Exemplexxx'
SELECT TRIM(TRAILING 'x' FROM 'xxxExemplexxx'); 	-- 'xxxExemple'
SELECT RTRIM('xxxExemple', 'x');					-- 'Exemplexxx'

Source: sql.sh

Sql rtrim

SELECT RTRIM('SQL Tutorial     ') AS RightTrimmedString;

Similar codes

1 vote333 views1 answer
User privileges postgresql information_schema
SQL
10 votes345 views4 answers
Inner join in update query mysql
SQL
1 vote451 views1 answer
Difference between where and having clause
SQL
2 votes331 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote324 views2 answers
Mysql disable foreign key checks
SQL
0 vote343 views1 answer
Mysql group by range
SQL
0 vote307 views2 answers
Postgresql could not start server mac
SQL
9 votes347 views4 answers
How to create new user and database postgresql in ubuntu
SQL
2 votes360 views5 answers
Eloquest how to select one specific column in database
SQL
1 vote355 views3 answers
Execute sp in sql server
SQL