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 vote324 views1 answer
Sql server udf performance
SQL
0 vote353 views1 answer
Select true if exists on another table or false sqlserver
SQL
10 votes341 views2 answers
Select nextval from sequence oracle
SQL
1 vote349 views2 answers
Oracle list service names
SQL
0 vote356 views1 answer
Oracle list datafiles
SQL
2 votes331 views2 answers
Mamp connect mysql terminal
SQL
0 vote360 views1 answer
How to run mysql on terminal mac
SQL
10 votes345 views2 answers
Oracle alter sequence nextval
SQL
3 votes318 views1 answer
Mysql replace string in table
SQL
0 vote363 views1 answer
Pl sql disable trigger
SQL