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 votes318 views3 answers
How do I add a user to a postgres database? cli
SQL
-1 vote292 views2 answers
How to select the lowest values from table per client sql
SQL
1 vote298 views3 answers
Mysql Server Start
SQL
-1 vote281 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote279 views1 answer
Take sql dump in to file
SQL
1 vote270 views3 answers
Remove unique key from a table
SQL
0 vote288 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote284 views1 answer
Sql server remove 0 from left
SQL
0 vote291 views1 answer
Regex mongoose
SQL
12 votes283 views1 answer
Docker run mysql image
SQL