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

0 vote138 views1 answer
Sql select upcoming birthdays
SQL
2 votes153 views1 answer
Oracle trace file
SQL
0 vote154 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote130 views1 answer
C# mysql data reader from two tables
SQL
22 votes163 views3 answers
Sql cheat sheet
SQL
0 vote149 views2 answers
How to find max and min salary in sql
SQL
0 vote171 views1 answer
Jooq replace
SQL
0 vote140 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote127 views2 answers
Nosqlbooster query other collection
SQL
0 vote144 views1 answer
Update view sql
SQL