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 vote117 views1 answer
Mysql add root password
SQL
0 vote130 views1 answer
Show all sequences postgres
SQL
2 votes111 views1 answer
Oracle table size
SQL
1 vote108 views1 answer
Delete row mssql
SQL
0 vote114 views1 answer
Rollback to name in sql
SQL
1 vote108 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
1 vote99 views1 answer
Mysql count all table rows
SQL
1 vote108 views2 answers
Oracle replace
SQL
0 vote104 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote127 views1 answer
Sqlalchemy _in array sqlite
SQL