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 vote339 views1 answer
Name of today sql
SQL
0 vote306 views1 answer
Change data type in mysql
SQL
0 vote334 views1 answer
With_for_update sqlalchemy
SQL
0 vote339 views1 answer
Oracle for loop on list
SQL
1 vote340 views3 answers
Nth highest salary
SQL
0 vote377 views1 answer
Postgres - Login and connect as default user
SQL
0 vote330 views1 answer
Mariadb select limit offset
SQL
5 votes283 views1 answer
Alter table default value mysql
SQL
1 vote322 views1 answer
Decalre temp table sql
SQL
0 vote344 views1 answer
Rows, INSERT INTO, Returning
SQL