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

1 vote305 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote291 views1 answer
10000000000000000000 am to meters
SQL
1 vote305 views2 answers
Mssql show database size
SQL
0 vote316 views1 answer
Last date for each user sql
SQL
0 vote321 views3 answers
Mysql regex replace
SQL
0 vote298 views1 answer
Big table in mysql
SQL
2 votes358 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote312 views1 answer
Select all columns except one sql
SQL
0 vote309 views1 answer
How to order result of subquery in select
SQL
1 vote294 views1 answer
Oracle user last connected
SQL