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

2 votes313 views1 answer
Add default sql server
SQL
13 votes326 views6 answers
Mysql remove duplicates
SQL
0 vote321 views2 answers
Sqlite unix timestamp
SQL
3 votes296 views1 answer
Index using in query plsql
SQL
3 votes371 views2 answers
Wp do sql query from function
SQL
3 votes325 views1 answer
Oracle drop user
SQL
25 votes345 views4 answers
Sqlserver add column
SQL
0 vote345 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote327 views1 answer
Get current date data in mysql
SQL
0 vote303 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL