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 vote143 views2 answers
How to display top 50 rows?
SQL
1 vote119 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote157 views1 answer
Sql common columns
SQL
0 vote146 views1 answer
Why we have to set the password for my sql server
SQL
3 votes156 views3 answers
Docker create postgresql database
SQL
0 vote161 views1 answer
Sort by last two number sql
SQL
4 votes192 views1 answer
Postgresql change default value
SQL
0 vote187 views2 answers
Suse Linux restart MySQL
SQL
1 vote168 views1 answer
Oracle sequence last_number
SQL
3 votes145 views2 answers
Oracle grants
SQL