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 vote81 views4 answers
Sql limit 1 offset 1
SQL
0 vote127 views1 answer
Sql how to get courses that i have made prerequisites
SQL
4 votes118 views3 answers
Oracle sql first day of quarter
SQL
9 votes137 views2 answers
Sql limit to 5 results
SQL
0 vote118 views2 answers
How to set global time_zone in mysql
SQL
0 vote77 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote114 views1 answer
Create function syntax sql server
SQL
1 vote124 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote149 views1 answer
Sql count total by foreign key
SQL
0 vote134 views1 answer
SQL Error 1040 : Too many connections
SQL