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 vote187 views1 answer
Setting default value for Boolean data type in SQL
SQL
1 vote138 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote155 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote132 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
13 votes143 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
1 vote146 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote149 views1 answer
Command line mysql xampp
SQL
0 vote125 views1 answer
Mysql create table columns with spaces
SQL
0 vote144 views1 answer
Oracle change password expiration policy
SQL
0 vote131 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL