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 vote204 views1 answer
Capitole toulouse
SQL
0 vote193 views1 answer
Create mysql pool connection python flask
SQL
0 vote210 views1 answer
Consecutive numbers sql
SQL
8 votes176 views5 answers
Grant permission in postgres
SQL
1 vote220 views1 answer
Postgresql blocked on mac
SQL
3 votes209 views2 answers
MySQL query to get column names
SQL
0 vote188 views1 answer
Java check if something is in mysql table
SQL
0 vote183 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote177 views1 answer
Drop constraint in ms sql
SQL
2 votes223 views6 answers
In operator in sql
SQL