Sql rtrim

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

3 votes107 views1 answer
Null sql
SQL
0 vote103 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
8 votes92 views1 answer
Ltrim sql
SQL
0 vote109 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote107 views2 answers
Postgresql get long running queries
SQL
0 vote99 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote130 views2 answers
Clauses in mysql
SQL
0 vote99 views4 answers
Restart MySQL
SQL
4 votes109 views1 answer
Sql select limit range
SQL
5 votes103 views3 answers
Sql make column nullable
SQL