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 votes332 views1 answer
How to create sql database
SQL
1 vote338 views1 answer
Sql select max value from multiple rows
SQL
9 votes329 views5 answers
Sql limit
SQL
3 votes342 views2 answers
How to open postgresql in windows
SQL
1 vote341 views1 answer
Sql server 2012 query history
SQL
12 votes309 views1 answer
How to change the value of a table in sql
SQL
0 vote323 views1 answer
Call rest api from postgresql
SQL
0 vote307 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote405 views1 answer
Calculer pourcentage mysql
SQL
21 votes317 views3 answers
Sql average
SQL