Ltrim sql

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 vote195 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
18 votes206 views3 answers
Get the list of all tables in sql server
SQL
2 votes202 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote195 views2 answers
Sql example query
SQL
1 vote195 views1 answer
Increase date by one day in sql oracle
SQL
3 votes199 views2 answers
How to start postgresql on windows
SQL
8 votes224 views2 answers
Update sql server from another table
SQL
0 vote196 views1 answer
Console output pl sql
SQL
0 vote194 views2 answers
Postgres another version
SQL
0 vote186 views1 answer
Mysql pv progres
SQL