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

0 vote246 views1 answer
Sql last 7 days
SQL
56 votes465 views5 answers
Psql create user
SQL
9 votes274 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote263 views1 answer
Why we have to set the password for my sql server
SQL
1 vote268 views1 answer
Where to locate set password for mysql
SQL
0 vote257 views1 answer
Jenkins SQLCMD run
SQL
0 vote236 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote262 views1 answer
Sql server select value large text
SQL
4 votes801 views1 answer
Oracle show errors
SQL
0 vote270 views1 answer
Materialized view redshift
SQL