SQL trim

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

0 vote139 views1 answer
Change schema of all tables postgres
SQL
0 vote147 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
3 votes149 views1 answer
Postgres add not null to existing column
SQL
0 vote166 views1 answer
Authentication modes in sql server
SQL
57 votes327 views6 answers
Mysql alter table add column
SQL
1 vote145 views1 answer
Calculate age in sql postgresql
SQL
27 votes172 views5 answers
Mysql set password for user
SQL
10 votes154 views1 answer
How to import database in mysql by cmd
SQL
0 vote157 views1 answer
Soql last week
SQL
8 votes162 views1 answer
Alter tablespace add datafile autoextend
SQL