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 vote315 views1 answer
Export mysql table to file
SQL
0 vote316 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote413 views1 answer
How to check foreign key constraint in sql
SQL
8 votes348 views1 answer
Check mysql version phpmyadmin
SQL
0 vote312 views1 answer
Not between mysql
SQL
0 vote304 views1 answer
Sql from null to not null
SQL
2 votes309 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote322 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote312 views1 answer
Check index sql server
SQL
0 vote331 views1 answer
User defined variables in sql
SQL