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 vote119 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
5 votes109 views1 answer
Mysql get last day of month
SQL
1 vote110 views1 answer
Mamp mysql path mac
SQL
0 vote118 views1 answer
Not equal to blank in mysql
SQL
-1 vote124 views1 answer
Mysql select count if contains
SQL
0 vote128 views1 answer
Sql convert float to string
SQL
5 votes121 views3 answers
Mysql remove unique constraint
SQL
0 vote115 views1 answer
Sql replace id with name from another table
SQL
1 vote120 views1 answer
Oracle lowercase
SQL
1 vote119 views1 answer
Isnull sql server
SQL