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

19 votes292 views1 answer
Sqrt(-1)
SQL
0 vote351 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
3 votes307 views3 answers
Into in sql
SQL
13 votes323 views2 answers
Get tables in database sql
SQL
1 vote332 views1 answer
Sql server insert into temp table
SQL
0 vote339 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote260 views1 answer
Sqlalchemy existing database
SQL
0 vote320 views1 answer
T sql cursor tr
SQL
4 votes325 views2 answers
Mysql delete user if exists
SQL
4 votes293 views2 answers
Oracle set date format
SQL