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

0 vote182 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote177 views2 answers
Oracle sql for each row
SQL
0 vote188 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
9 votes199 views4 answers
SQL Date Format
SQL
0 vote131 views1 answer
Delete all rows from table sqlite
SQL
2 votes179 views1 answer
Q operator in oracle
SQL
1 vote146 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote178 views1 answer
Python mysql query to dataframe
SQL
1 vote130 views1 answer
Athena query timestamp greater than
SQL
0 vote177 views1 answer
Get the First and Last Word from a String or Sentence
SQL