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

2 votes281 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
2 votes296 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
2 votes251 views2 answers
Checking data type in sql server
SQL
0 vote270 views1 answer
Repeatable read trong sql server
SQL
1 vote247 views1 answer
Postgres regex remove special characters
SQL
0 vote287 views1 answer
Bitmap join index
SQL
-2 votes242 views1 answer
How to open database
SQL
0 vote284 views1 answer
T-sql update table variale
SQL
0 vote248 views1 answer
Mysqlimport
SQL
103 votes432 views1 answer
Like sql
SQL