/SQL/Sql remove characters from string right

Sql remove characters from string right

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

Similar codes

1 vote119 views1 answer
Mysql drop key
SQL
0 vote135 views1 answer
Sql show founctions
SQL
1 vote121 views1 answer
Install postgresql on raspberry pi
SQL
1 vote126 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote123 views1 answer
Database traccar
SQL
3 votes111 views1 answer
MySQL DELETE JOIN
SQL
1 vote109 views1 answer
Using SQL in rails migration
SQL
16 votes133 views5 answers
Select last row in sql
SQL
1 vote119 views1 answer
Order by oracle
SQL
0 vote111 views1 answer
Why we have to set the password for my sql server
SQL