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 vote210 views1 answer
Mysql delete from where like
SQL
0 vote226 views1 answer
Drop database using terminal postgres
SQL
6 votes213 views2 answers
Sql display max value
SQL
0 vote219 views1 answer
Fast sql column count
SQL
0 vote307 views2 answers
Sqlalchemy default value for column
SQL
0 vote222 views1 answer
Oracle current timestamp
SQL
-1 vote216 views1 answer
Partial search in sql
SQL
2 votes226 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
5 votes209 views2 answers
Postgre insert select
SQL
1 vote221 views1 answer
Rermove categories woocommerce sql
SQL