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 vote200 views2 answers
Oracle list service names
SQL
1 vote161 views1 answer
Unique vs distinct sql
SQL
3 votes199 views1 answer
Sql cast to integer
SQL
3 votes203 views2 answers
Mysql config user password
SQL
0 vote269 views2 answers
Return the number of records in a single table mysql
SQL
0 vote223 views1 answer
Plpgsql if statement
SQL
4 votes189 views1 answer
Psql get sequences
SQL
13 votes195 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
1 vote241 views1 answer
Key validation sql
SQL
4 votes238 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL