Sql remove leading spaces

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

4 votes140 views3 answers
Is not null sql
SQL
1 vote126 views1 answer
Mysql how to reset primary key
SQL
0 vote135 views1 answer
How to join result table in mysql
SQL
0 vote129 views1 answer
Mysql join same table multiple times group by
SQL
2 votes128 views1 answer
Possgress drop if exists table
SQL
1 vote136 views1 answer
Round one decimal place mysql
SQL
2 votes138 views1 answer
How to get weekday from old date in sql
SQL
4 votes129 views1 answer
Oracle delete last row
SQL
0 vote126 views1 answer
Oracle sql developer closed connection
SQL
3 votes127 views2 answers
Oracle sql drop sequence
SQL