Sql trim from string

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

2 votes155 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote144 views1 answer
Pl sql join 3 tables
SQL
0 vote187 views1 answer
Capabilities of sql select statements
SQL
1 vote95 views1 answer
Mssql string length
SQL
0 vote151 views1 answer
Sql find table by name
SQL
0 vote136 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote121 views1 answer
Login phpmyadmin without password
SQL
0 vote146 views1 answer
Sqlplus change user
SQL
0 vote124 views1 answer
Create bakupd database sqlserver
SQL
0 vote154 views1 answer
Alter fedora mysql 8.0 user
SQL