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

1 vote310 views4 answers
Aggregate function in sql
SQL
-1 vote323 views1 answer
Auto increment psql not primary key
SQL
1 vote286 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote300 views1 answer
Postgresql heritage
SQL
7 votes309 views2 answers
Mysql default value
SQL
0 vote317 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote318 views1 answer
Sql put two columns into one
SQL
0 vote296 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
-1 vote346 views2 answers
Sql search all tables for attributes
SQL
2 votes371 views3 answers
Mysql unix timestamp to date
SQL