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

-2 votes202 views1 answer
Modify column name in tsql
SQL
0 vote189 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote364 views1 answer
The package java.sql is not accessible
SQL
0 vote189 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote206 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote207 views1 answer
Sql drop schema
SQL
-1 vote221 views4 answers
Restart mysql server ubuntu
SQL
-1 vote200 views1 answer
Su: Authentication failure mysql
SQL
0 vote232 views1 answer
Postgres docs /copy metacomand
SQL
0 vote218 views1 answer
Mysql value ends with
SQL