Trim 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

Sql trim from string

SELECT TRIM(' text  ');			
SELECT TRIM(BOTH 'x' FROM 'xtextx');

SQL trim

TRIM([LEADING | TRAILING | BOTH] [characters] FROM string)Code language: SQL (Structured Query Language) (sql)

-1

Source: postgresqltutorial.com

Similar codes

-1 vote190 views4 answers
Restart mysql server ubuntu
SQL
0 vote199 views1 answer
Postgresql stored procedure update table values
SQL
1 vote191 views1 answer
Database Queries
SQL
1 vote187 views2 answers
Drop table if exists test
SQL
25 votes183 views6 answers
Sql update query
SQL
49 votes194 views6 answers
Mysql add column to table
SQL
19 votes179 views2 answers
Mysql add column after another
SQL
0 vote179 views1 answer
Set a default value for a column in sqlite
SQL
3 votes177 views2 answers
Postgres alter table owner
SQL
0 vote160 views1 answer
Count column of tables psql
SQL